Microsoft Office Tutorials and References
In Depth Information
Chapter 16: Writing Home about Text Functions
Try it yourself! The LEFT function is really handy and so easy to use!
1.Positionthecursorinthecellwhereyouwanttheextractedstring
displayed.
2. Enter =LEFT( to start the function.
3. Click the cell containing the original string, or enter its address.
4. Enter a comma ( ,).
5. Enter a number.
This number tells the function how many characters to extract from the
left of the larger string. If you enter a number that is equal to or larger
than the number of characters in the string, then the whole string is
returned.
6. Type a ), and press Enter.
Swinging to the RIGHT
Excel does not favor sides. Because there is a LEFT function, there also is a
RIGHT function. RIGHT extracts a certain number of characters from the right
of a larger string. It works pretty much the same way as the LEFT function.
Column C of Figure 16-1 uses the RIGHT function to extract the rightmost four
characters from the product codes. Cell C4, for example, has this formula:
=RIGHT(A4,4).
Here’s how to use the RIGHT function:
1.Positionthecursorinthecellwhereyouwanttheextractedstring
displayed.
2. Enter =RIGHT( to start the function.
3. Click the cell containing the original string, or enter its address.
4. Enter a comma ( ,).
5. Enter a number.
This number tells the function how many characters to extract from the
right of the larger string. If you enter a number that is equal to or larger
than the number of characters in the string, then the whole string is
returned.
6. Type a ), and press Enter.
Search JabSto ::




Custom Search