Excel Forum



Excel Magic Trick #221: LEN function Counts Spaces


See how to use the LEN function to count charters including spaces. Then see how to use the LEN, SUBSTITUTE, and TRIM function to count characters but not count unwanted spaces.





Got a Question? Ask it Here in the Forum.