How to use LEN function in excel 2007


What is LEN function in excel ???

The LEN (length) function returns  the number of characters in a text string. you can see the below image to know more.


Len function calculates the value which you selected + spaces & , & . Etc. for example i have selected my page name which i typed in excel, the result is 25 means its calculated characters as well as full stop (.)
the same thing for spaces also. check the  below animated image to learn the function.





Author: Pavithra Damodhan

Hello, I am Author, decode to know more: In commodo magna nisl, ac porta turpis blandit quis. Lorem ipsum dolor sit amet, consectetur adipiscing elit. In commodo magna nisl, ac porta turpis blandit quis. Lorem ipsum dolor sit amet.

0 comments:

E-mail Newsletter

Sign up now to receive breaking news and to hear what's new with us.

Recent Articles

© 2014 Howto- Excel | Distributed By My Blogger Themes | Created By BloggerTheme9
TOP