Learn how to convert text in a cell into multiple columns

Here are the steps to follow in this lesson:

  1. Highlight the cells containing the text that you wish to extract.
  2. From the Data menu, choose “Text to Columns” and follow the Wizard.
  3. Choose the correct “Delimiter,” e.g. “Space” or “Tab.”
  4. Preview the result and click Finish.
  5. 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