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 the data I need to have each set in separate columns is there a quick way to do this? many thanks
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.
2 Replies
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!
