RE: re: OT: Excel Pivottables

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

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



_____