Separating Word document information in Excel - AdvantEdge Training & Consulting

Separating Word document information in Excel

There are times that information has been exported or written in such a manner that it appears something like this:
Mouse; Mickey; 222-333-4444
Mouse; Minnie; 222-333-4444
Duck; Donald; 222-333-4444
Sam; Yosemite; 222-333-4444
Dog; Pluto; 222-333-4444
Duck; Daffy; 222-333-4444
Coyote; Wile E.; 222-333-4444
Bird; Tweety; 222-333-4444
Cat; Sylvestor; 222-333-4444

If this information needs to be quickly placed in an Excel table, it can be done by using the Text to Column command.
1. Copy information and paste in Excel.
2. Under the Data tab, click the Text to Columns command

separate text in excel

  • This will show the selected data to be altered, so ensure the information selected is correct.

3. Once data confirmed, click the Next button.

separate text in excel
4. Select the symbol being used to separate the information, in this case it is a semi-colon.

separate text in excel

  • Once selected, you will see the information separate.
  • Confirm and click Next.

5. The next screen will allow you to place data in the cells you want to start with and what type of format to initially use for the information. Once completed, click Finish.

separate text in excel
6. The finished product looks like the following:

separate text in excel

From here, information can be inserted into table or headers can be added.

Get the most out of  Excel with a training class from AETC.

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top