The Text to Columns wizard can also be used to split one column into three or more columns – just insert the number of columns required before starting the wizard.

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.

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 ...

Click the column A header to select the entire column. Click the Data tab on the ribbon and then click Text to Columns. The Convert Text to Columns Wizard window will appear.

Simply press CTRL and the numeric pad's + key—the non-Numpad + key won't work—to automatically resize all columns to fit the text contents. You'll see the entire text in the column instead of ...