Introduction to Strings
Strings are blocks of text that appear in Excel, like names of people, names of cities, e-mail addresses, or names of items sold in a store. When we type strings into Excel, we always use quotation marks around them to tell Excel that what it’s about to read is one coherent block of text.
What are String Functions in Excel ?
In Excel, there are multiple string (text) functions that can help you to deal with textual data. These functions can help you to change a text, change the case, find a string, count the length of the string, etc. In this post, we have covered top text functions.
Download Practice files for Text Functions
Download Excel Text Sample Files to move along with the tutorial and master the skill of using LEN Function in Excel.
What is LEN Function in Excel ?
LEN function returns the count of characters in the value. In simple words, with the LEN function, you can count how many characters are there in value. You can refer to a cell or insert the value in the function directly.
What is the Syntax of LEN Function ?
LEN(text)
Arguments related to LEN Function
- text: A string for which you want to count the characters.
Example of LEN Function in MS EXCEL
In the below example, we have used the LEN to count letters in a cell. “Hello, World” has 10 characters with a space between and we have got 11 in the result.
In the below example, “22-Jan-2016” has 11 characters, but LEN returns 5.
The reason behind it is that the LEN function counts the characters in the value of a cell and is not concerned with formatting.
