Number of characters in an Excel cell: counting formula and function

When working with Excel spreadsheets, in some cases, the user needs to determine the number of characters in a particular cell. If the contents of the cell are insignificant, then this can be done manually without much effort. But what if there are a lot of characters or, say, the contents of a cell changes depending on some factor or action in the table.

In fact, performing the task is quite simple, because Excel provides a function called “DLSTR”which is applicable in such cases.

Leave a Reply