Here are the steps to follow in this lesson:
- Use the =LEFT() Function to extract characters at the beginning of a text string.
- Use the =RIGHT() Function to extract characters at the end of a text string.
- Be sure to distinguish “stored cell” entries from “formatted” or “displayed” cell values.
- Before you use the =MID() Function to extract characters in the middle of a text string, be sure to locate the starting location.
- 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.
Link to this post!