In the previous post, we saw ‘Text Function | How to use the Excel UPPER Function?’, now we will learn about ‘How to use the Excel LEN function?’.
Where to Find the Text Function?
To find the text function in excel open excel and click on the “Blank” to open a blank excel worksheet now click on the ‘Formula Tab’ and under ‘Function Library’ click on the ‘Text’ option as shown below:
You can also see the text function via shortcut key – press ‘ALT + M + T’ after that select the text function that you want to use.
What is Excel LEN Function?
The Excel LEN function returns the number of characters in a text string.
Syntax
LEN(text)
Arguments
The LEN function syntax has the following arguments:
Text Required. The text whose length you want to find. Spaces count as characters.
Understand With Example
If you want to make the lower case, The Excel LOWER function Converts all uppercase letters in a text string to lowercase. It ignores space, numbers, and punctuation. Visit this link – Excel LOWER Function.
The Excel PROPER function Capitalizes the first letter in a text string and any other letters in the text that follow any character other than a letter. It Converts all other letters to lowercase letters. Visit this link – Excel PROPER Function
For Latest Updates & Learning Join Our YouTube Channel: Join Now
