ie

Alan Reid would return a value of 9

Hi Alan

use the LEN function
e.g. with Alan Reid in cell A1
=LEN(A1)

Cheers
JulieD

"Alan Reid" <Alan wrote in message
...
ie

Alan Reid would return a value of 9

If the Alan Reid is in cell A1, in B1 put:
=LEN(A1)

tj

"Alan Reid" wrote:

ie

Alan Reid would return a value of 9

Alan Reid Wrote:
ie

Alan Reid would return a value of 9

*=len(cell_number) *

is probably the formula that you need.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=318810