Tip of the Day | Saturday 5 September 2026

Discover new tools to get things done.

Count Characters in Selected Cell...

This tool shows you the number of characters in the currently selected cell.

Knowing this is helpful when you need to:

  • Check if the text fits within a character limit
  • Prepare data for import/export into other systems
  • Analyze or validate text length in cells

For example, if the cell contains the value "Microsoft Excel", the result will be 15 characters.

Compared to using Excel's =LEN() formula, this tool:

  • Works instantly without inserting a formula
  • Doesn't change or clutter your worksheet
  • Works even on protected sheets where formulas can't be entered

Tip:
If you need to check multiple cells at once, using Excel's =LEN() formula is more efficient.

Starting this tool

Specify a Keyboard Shortcut: ASAP Utilities  › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Tip:Alt+P for the previous tool.