Excel Forum
Similar Content
Formulas to Remove First or Last Character from a Cell in Excel
Tutorial: Formulas that allow you to quickly and easily remove the first or last character from a ce...
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
Formula to Delete the First or Last Word from a Cell in Excel
Tutorial: Excel formula to delete the first or last word from a cell. You can copy and paste the for...



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.