Re: re: OT: Excel Pivottables

[Doogie Brodie <ukhad@xxxxxxx>]

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.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