Len(Text),,,counts the number of characters

[postlink]http://mastermicrosoftexcel.blogspot.com/2010/05/lentextcounts-number-of-characters.html[/postlink]http://www.youtube.com/watch?v=sK5cmXMkG_gendofvid
[starttext]
You can calculate the number of characters in a string text, cells.
This also teaches about two formulas: len and trim,which uses to remove left&right spaces.

for practice file click here
[endtext]

0 comments:

Post a Comment