Separate the contents of one Excel cell into separate columns. For example, you can separate a column of full names into ...

Separate the contents of one Excel cell into separate columns.

For example, you can separate a column of full names into separate first and last name columns.

In Word, use this feature to convert the selected text into a table, splitting the text into columns at each comma, period, or other character you specify.