Here are the steps to follow in this lesson:
- Highlight the cells containing the text that you wish to extract.
- From the Data menu, choose “Text to Columns” and follow the Wizard.
- Choose the correct “Delimiter,” e.g. “Space” or “Tab.”
- Preview the result and click Finish.
- Cut and paste as needed.
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.
Related Videos
Link to this post!
Speak Your Mind