Count each Cell's Characters (Text Length) for a Column

DigDB

Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download ^{free 15-day trial} | Purchase | FAQ | Contact

Count each Cell's Characters (Text Length) for a Column

Sometimes a column has to meet the requirement of not exceeding a certain length in the count of text characters. DigDB allows you to calculate each cells' text length easily.

Click a single cell in the column you want to count, then invoke 'DigDB->Column->Text Length'

Practice file - count-column-length-demo.xls (16k)
The column will be automatically selected. Click OK to start counting
In result, a new column will be inserted to store the count of cell characters. The original column will remain unchanged.

You can now sort this column to see the longest or shortest cells.

Need more?

Browse the complete list of DigDB's powerful features listed on the front page.
If you see errors or things not working, check out our error reference page.

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.