LEN counts "Space" as a character
Hello,
How do I prevent LEN from counting spaces between words as characters?
Thank you.
=LEN([Letters]@row) * 10.75 * Height@row
Best Answers

Create a helper column. Use the SUBSTITUTE function to replace the blanks in the text with nothing, thereby removing the blanks. Then use LEN against the helper column.
You could also do it without the helper column by placing the SUBSTITUTE within the LEN formula:
=LEN(SUBSTITUTE([Letters]@row, " ", ""))
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

=LEN(SUBSTITUTE([Letters]@row, " ", "")) works.
=LEN(SUBSTITUTE([Letters]@row, " ", "")) * 10.75 * Height@row
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers

Create a helper column. Use the SUBSTITUTE function to replace the blanks in the text with nothing, thereby removing the blanks. Then use LEN against the helper column.
You could also do it without the helper column by placing the SUBSTITUTE within the LEN formula:
=LEN(SUBSTITUTE([Letters]@row, " ", ""))
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Works well, although I hope that there's a better way to do it by using exact cell.
Thank you, Jeff.

=LEN(SUBSTITUTE([Letters]@row, " ", "")) works.
=LEN(SUBSTITUTE([Letters]@row, " ", "")) * 10.75 * Height@row
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

It works perfectly. Thanks, Jeff, I appreciate it
Help Article Resources
Categories
Check out the Formula Handbook template!