Skip to main content
Skip to main content
Microsoft 365

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: View live transcripts in Microsoft Teams meetings, track Excel changes, and increase hybrid work security—here’s what’s new to Microsoft 365

View live transcripts in Microsoft Teams meetings, track Excel changes, and increase hybrid work security—here’s what’s new to Microsoft 365

This month, we're announcing some top requested features like tracking changes in Excel and live transcriptions in Teams, as well as some soon-to-be-favorites like meeting recaps, turning Word documents in presentations, and more.

Image for: Family hanging out at home baking holiday cookies using Lenovo Ideapad Flex 3 to make holiday cards

New apps and features in Microsoft 365 for individuals and families this fall

Since we introduced Microsoft 365 to individuals and families earlier this year, we have continued to deliver new innovations across our apps and services to help you and your family save time and stay connected. See what’s new below. Locate your loved ones and build better driving habits with Microsoft Family Safety Stay connected even…

Image for: A man is using his Lenovo laptop like a tablet while sitting in a comfortable chair in a Modern office setting

Microsoft Productivity Score and personalized experiences—here’s what’s new to Microsoft 365 in October

As I reflect on an action-packed few weeks, I’m struck by how much work has evolved in these past months. And I know our customers feel it too. After quickly moving to remote and hybrid work models this spring, organizations are now seeking sustainable ways to help people collaborate, be productive, and prioritize their wellbeing…