View Single Post
  #1   Report Post  
Larry Wallis
 
Posts: n/a
Default Calculating number of letters in a string ...

Looking for a way to calculate the number of characters in a text string. I
can use the LEN function.

e.g. If A1 contains "News Group", the number of characters is 9. Using the
LEN(A1) formula would give me 10 (includes the space).

How can I use this formula to omit the space?

Thanks.

Larry.