I'm going to use Microsoft Word to show you how to use this tool, but you can follow the same steps in Excel to achieve the ... click View > Split instead. This may be a better option if you ...

You can take the text in one column and split it into multiple columns using the Convert Text to Columns Wizard. To get started, open the Excel Sheet in which you would like to split a single ...