Learn to extract information from a text string

Here are the steps to follow in this lesson:

1. Use the =LEFT() Function to extract characters at the beginning of a text string.
2. Use the =RIGHT() Function to extract characters at the end of a text string.
3. Be sure to distinguish “stored cell” entries from “formatted” or “displayed” cell values.
4. Before you use the =MID() Function to extract characters in the middle of a text string, be sure to locate the starting location.
5. The =MID() Function requires 3 arguments.

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.