Unlike Word, where you can get easily the character count of the document using a tool in the menu bar, you will need to use the LEN function if you want to get a character count in Excel. Here’s how to use it.

How to get the character count of a single cell

You can use the LEN function to quickly count the number of characters in a single cell in two different ways.

To use the LEN function to get the character count, click the cell where you want to place the character count. After that, write , where cell is the actual cell you want to get the character count of. So if you want to get the character count of cell A1, you need to enter:=LEN(cell)

= LARGO (A1)

Enter the LEN function in a cell.

Click on any other cell and the character count will appear.

The character count of cell A1.

Or you can just copy the contents of the cell you want to get the character count from, paste it into the formula instead of the reference cell, and wrap it in quotes. For example:

= LEN ("¿Cuántos caracteres hay en esta celda?")

Paste the cell content into the formula.

This will return the same result.

If you’re analyzing data, you might also want to split text into multiple columns .

How to get the character count of multiple cells

The LEN function can also be used in combination with the SUM function to get the character count of multiple cells. First, click on the cell you’d like to place the word count in. Then enter this formula:

= SUMA (LARGO (A1), LARGO (A2))

Replace the cell numbers with your own.

Enter the combination of LEN and SUM functions.

Click any other cell and the character count will be returned.

The character count of cells A1 and A2.

You can add as many cells as you like in the formula.

It’s also easy combine text of these different cells into one.

How to get the count of a specific character in a cell

You can also use the LEN function to get the count of how many times a specific character appears in a cell. Select the cell you want the count to be returned, and then enter this formula:

= LONG (A1) -LEN (SUSTITUTO (A1, "a", ""))

Replace cell ( A1) with its cell reference and a with the character you would like to get the count for. In our case, we are looking for how many times aappears in cell A1.

Enter the LEN function to get the specific character count.

Click any other cell and the count for the specified character will be returned.

The count of the specified character.

That’s all about it. Excel is full of extremely useful features , from the COUNTIF function until the FREQUENCY function and lots different logic functions , all designed to streamline your workflow.

RELATED:   How to create a shortcut to Google Assistant Family Bell

Leave a Reply

Your email address will not be published. Required fields are marked *