Formatting columns in excel

New Contributor

I have been given a large data set (about 6000 rows) but it formatted incorrectly. The 3 data types have been inserted into the same column but separated by an indent (see photo below). to analyse the data I need to have each set in separate columns is there a quick way to do this? many thankshelp.PNG

2 Replies
best response confirmed by felixspiers (New Contributor)


Select the column.

On the Data tab of the ribbon, click Text to Columns.

Select Delimited, then click Next >.

Select Tab as delimiter, then click Finish.

Thank you!