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.

Copy information and paste in Excel.

Under the Data tab, click the Text to Columns command
0815_article2_01

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

Once data confirmed, click the Next button.

text to column excel

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

Once selected, you will see the information separate.

Confirm and click Next.

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.

The finished product looks like the following:

0815_article2_05

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

 

For more ways to make your work easier and more polished, check out our Word and Excel training courses

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