The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[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

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.