Using the Text to Columns Tool One way to split data into multiple columns in Microsoft Excel is to use the built-in Text To Columns tool. This method is handy if you prefer to work in a dialog ...

To get started, open the Excel Sheet in which you would like to split a single column into multiple columns. Then, go to the ‘ Data ’ tab and select the ‘ Text to Columns ’ section.