| The Office Newsletter is a
free, opt-in monthly publication full of tips like this one.
Just hit the Subscribe link (above). We promise not to use
your email address for evil, and we will never share your
information with anyone else. Excel: Two great functions, Left and Len
Left:
Returns the specified numbers of characters from the start
(left) of a text string.
The syntax is: Left(the text string, the number of
characters you want)
For example if cell A1 contains (615) 223-6789, and the
formula in cell B1 contains the formula
=Left(A1,5)
Cell B1 will display (615) because those are the leftmost five characters in
cell A1.
Len: Returns the number of characters in a text
string. Len has one argument: the text string.
For example, if cell A1 contains DataSchenk, and cell B1
contains the formula
=Len(A1)
Cell B1 will display 10.
If cell C1 contains the formula
=Len(A1)-1
Then cell C1 will display 9 - the length of the string minus
one.
Not sure why you care?
See this article. |
