How to count characters in Excel
One of the Excel questions we get asked the most is how to count the number of characters in a given cell. There’s a very simple solution to this problem: the
LEN( "It works!")
Excluding spaces from your character count
In some situations, you may want to exclude spaces from your character count. To do so, use the
LEN( SUBSTITUTE( "It works!", " ", ""))
In the example above, we use
Save an hour of work a day with these 5 advanced Excel tricks
Work smarter, not harder. Sign up for our 5-day mini-course to receive must-learn lessons on getting Excel to do your work for you.
- How to create beautiful table formatting instantly...
- Why to rethink the way you do VLOOKUPs...
- Plus, we'll reveal why you shouldn't use PivotTables and what to use instead...