Counting Characters


Posted by Andy on September 04, 2001 12:31 PM

How do i count how many characters i have in a cell? i.e. if A1 contained the word FOOT, how can i make B1 give the number 4. FOOTBALL would give me 8.

Posted by Aladin Akyurek on September 04, 2001 12:32 PM

In B1 enter: =LEN(A1) (NT)



Posted by Andy on September 04, 2001 12:35 PM

Jeez... simple... Thanks very much!!