LEN Function in Excel |
My Digital Quill | Excel Formulas and Functions #25 | LEN Function in Excel | Excel tips and tricks | Excel #shorts
LEN Function is a text function in Excel that returns the length of a string or text. It can be used to count the number of characters in a text string. This example explains on how to use LEN function utilizing simple syntax referencing the cell for which the characters are to be counted. The LEN function also counts the spaces as character along with the special characters that sensitizes the data quality of the data. This function can hence be used to quality check number of characters as provided in a data set as we can see in this example, where bank account number for employees are provided.
Credits:
Thumbnail Photo by Justin Morgan on Unsplash
Excel Superstar
• How to use LEN Function in Excel | Hindi
Please check out more Excel tips and tricks from the playlist link down below:
• Excel Tips and Tricks
Check this playlist for Excel formulas and functions:
• Excel Formulas and Functions Series
Free Excel Course available on formatting techniques in here:
• Excel Formatting Techniques
🔔 Subscribe for free Office Tutorials at My Digital Quill:
/ @mydigitalquill8945
#lenfunction #lenfunctioninexcel #excellenfunction #Excelformulasandfunctions #Exceltipsand tricks #Excelshorts
#MyDigitalQuill
Смотрите видео LEN Function in Excel | онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал My Digital Quill 29 Январь 2022. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 117 раз и оно понравилось 7 посетителям.
