View Single Post
  #2   Report Post  
Cutter
 
Posts: n/a
Default Count Text in a Cell


Use the LEN() function.

If A1 contains the word test

Then putting the formula =LEN(A1) in another cell will return 4

It also counts spaces.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=484407