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.
  • 0815_article2_02
  • Select the symbol being used to separate the information, in this case it is a semi-colon.
    0815_article2_03
  • a. Once selected, you will see the information separate.
  • b. 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
  • a. From here, information can be inserted into table or headers can be added.

For more word tips see our Word Training Classes.