We often need to measure the length of a text, for example if we write a text that will appear on a website. Typically, in a web shop the product introduction text has to be of a certain length in order to fit within the frames.

Of course, the easiest way to do this is in Excel. This is extremely easy – it only takes a few seconds:

**1. Import the text into Excel, or type it:**

**2. Use the LEN formula:**

To determine the length of the text in A2, use this formula:

**=LEN(A2)**

Copy down.

## Bonus trick: How to exclude spaces when you count characters in Excel

Use the SUBSTITUTE function to remove the spaces: =SUBSTITUTE(A2,” “,”") and wrap it inside the LEN function:

**=LEN(SUBSTITUTE(A2,” “,”"))**

Explanation: The SUBSTITUTE function substitutes the spaces, ” “, with nothing, “”.

Other easy tricks:

- Use Excel to Count Words
- How to avoid #DIV/0 and other Error Messages in Excel
- Use Excel to convert Arabic Numbers to Roman and back
- Highlight Cells in Excel that Contain a Formula

Are you using a non-English version of Excel? Click here for translations of the 100 most common functions.