How to Use LEN Function in Excel

Описание: In this Excel Function Explained video series, I’ll explain how to use LEN function in excel. Excel LEN function is mostly used to count the number of characters in a cell, data range or text strings in excel. Whenever you need to know how many characters you have in a certain data range, you can use LEN function in excel. Len is the short from of Length and thus it works accordingly, count the length of a strings.

Let’s move forward and learn how to use LEN formula in excel.

The Function looks like this =LEN (Text)

The LEN function has only one argument or parameter.
Text: In this parameter, we need to either write the text or specify the cell
from where we need to count the character number in excel.

Now there is one important thing you should consider while using this function.

It considers space, decimal or any symbol as a character.

This is how to use LEN in excel. Remember, using LEN function in excel you actually tell excel formula to count character length of given text. So this is how you get a character count in excel.

#Excel #Function #LEN
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
  / excel10tutorial  
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel:
https://bit.ly/2UngIwS

Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse

Social media:
Facebook:   / excel10tutorial  
Twitter:   / excel10tutorial  
Blogger: https://excel10tutorial.blogspot.com
Tumblr:   / excel10tutorial  
Instagram:   / excel_10_tutorial  
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG Become a member and enjoy exclusive perks while supporting the channel you love!
   / @excel10tutorial