SOLVED

Formatting columns in excel

Copper 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 (Copper Contributor)
Solution

@felixspiers 

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!
1 best response

Accepted Solutions
best response confirmed by felixspiers (Copper Contributor)
Solution

@felixspiers 

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.

View solution in original post