[Date Prev][Date
Next][Thread Prev][Thread Next][Date
Index][Thread Index]
Re: 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.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
Home |
Main Index |
Thread Index
|