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.