Skip to main content

Use the LEN function to get a cell’s character count

Ever wonder where the character count command is in Excel? It doesn’t exist, at least not in the same sense as Word’s word count feature–Excel isn’t a word processor. You can’t select a block of text and quickly see how many characters the selection contains. But Excel does have a nifty little function, LEN, that lets you count characters by using a formula.

LEN takes a text string as its only input – though of course you can use a cell reference instead of actual text data. To use LEN, just enter the formula as you would any other. Here’s an example:

Counting characters using the LEN function

You can see the formula in the formula bar (the selected cell is D9). When the text in C9 changes, the LEN function recalculates.

What about word count? That’s a little trickier–but you can read more about counting in the Excel Help article Ways to count values in a worksheet, which includes a section on word count.

 — Steven Thomas

You may also like these articles

Image for: A woman sitting on a couch using her PC laptop.

Introducing Money in Excel, an easier way to manage your finances

Today, with the launch of Money in Excel, we are embarking on a journey to simplify your day-to-day money decisions to help you stay on track of your longer-term financial goals.

Image for: A man working from home.

Get Yammer in Teams and new features in Microsoft Edge—here’s what’s new to Microsoft 365 in April

In this world of remote everything, our customers are discovering so many new ways to work and learn online. We’re committed to shipping updates and improvements to our tools that help you stay connected, productive, and secure through the current crisis and beyond.

Image for: Image of a father and daughter on a couch.

Introducing the new Microsoft 365 Personal and Family subscriptions

The subscription service for your life to make the most of your time, connect, and protect the ones you love.