RE: Re: OT: Excel Pivottables

["White, Peter" <peter.white@xxxxxxx>]

thanks again; I'd managed to do the same, but in about 6 hidden columns
rather than 1 nice, tidy formula.  As you can guess, my spreadsheets mostly
work, but rarely fit on a floppy!

P.
-----Original Message-----
From: mark90h [mailto:mark.heyhoe@xxxxxxx]
Sent: 22 January 2004 14:44
To: ukha_d@yahoogroups.com
Subject: [ukha_d] Re: OT: Excel Pivottables


Hi,
Assuming the value is in Cell B1 the formula would be:
=MID(B1,FIND(",",B1)+1,FIND(",",B1,FIND(",",B1)+1)-FIND(",",B1)-1)

HTH,
Mark

--- In ukha_d@yahoogroups.com, "White, Peter"
<peter.white@b...>
wrote:
> that's a big help, thanks.
>
> -----Original Message-----
> From: Doogie Brodie [mailto:ukhad@xxxxxxx...]
> Sent: 22 January 2004 12:58
> To: ukha_d@yahoogroups.com
> Subject: Re: [ukha_d] re: OT: Excel Pivottables
>
>
> White, Peter wrote:
>
> > Where n is a numeric, a is an alpha/numeric, and the other
numbers are
> > constants.  The last field is only limited by the length of the
SMS
> message.
> > Because mobile numbers over Europe vary in length, doing a
simple count in
> > to the text string doesn't work, it has to be a formula that
knows to
> start
> > from the comma.
> >
> > Any help very welcome!
>
> Don't have a lot of time to look at it at the moment, but your
starter
> for 10 is the FIND function.... =FIND(",",A1) will return
the
position
> of the first comma in your string, and =FIND(",",A1,B1+1)
will
return
> the position of the second comma, assuming the first formula was
put in
> cell B1.
>
> --
> Doogie
>
>
> UK Home Automation Meet 2004 - BOOK NOW!
> http://www.ukha2004.com <http://www.ukha2004.com>
>
> http://www.automatedhome.co.uk
<http://www.automatedhome.co.uk>
> Post message: ukha_d@yahoogroups.com
> Subscribe:  ukha_d-subscribe@yahoogroups.com
> Unsubscribe:  ukha_d-unsubscribe@yahoogroups.com
> List owner:  ukha_d-owner@yahoogroups.com
>
>
>
>    _____
>
> Yahoo! Groups Links
>
>
> *      To visit your group on the web, go to:
> http://groups.yahoo.com/group/ukha_d/
> <http://groups.yahoo.com/group/ukha_d/>
>
>
> *      To unsubscribe from this group, send an email to:
> ukha_d-unsubscribe@yahoogroups.com
> <mailto:ukha_d-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> *      Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service
> <http://docs.yahoo.com/info/terms/>
.
>
>
>
>
> [Non-text portions of this message have been removed]



UK Home Automation Meet 2004 - BOOK NOW!
http://www.ukha2004.com

http://www.automatedhome.co.uk
Post message: ukha_d@yahoogroups.com
Subscribe:  ukha_d-subscribe@yahoogroups.com
Unsubscribe:  ukha_d-unsubscribe@yahoogroups.com
List owner:  ukha_d-owner@yahoogroups.com