Forum Discussion
Solved
Formatting columns in excel
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 th...
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.
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!