View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR
 
Posts: n/a
Default Creat Formula for Counting Text

Do you mean count characters (including spaces):

=LEN(A1)

Don't count spaces:

=LEN(SUBSTITUTE(A1," ",""))
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"soniadufferin" wrote in message
...
How do I create a formula to count Text in Cells?