How to Split One Column into Multiple Columns in Excel | How to Use Text to Columns in Excel

In this video, we’ll show you How to Make One Long Column into Multiple Columns in Excel.

Too much data in a single column can make your Microsoft Excel spreadsheet harder to read. The Text to Columns feature allows you to split one column into multiple columns.

Here’s how to do it.

1) Open your Excel file.
2) Select the column that you want to split.
3) Go to the Data tab and find the Data Tools section.
4) Then click the Text to Columns button.
5) The Convert Text to Columns wizard opens. Select the Delimited term and click Next.
6) Now we specify which character Excel should use to split the data.
7) For example, check on the Space box. A preview of the results displays at the bottom. Then click Next.
8) The last window lets the user select each column’s data format. By default, the General option is selected, which ensures that the columns have the same format as the original cells. If you don’t want to use the default, highlight each column and make a selection. Check if the result is showing right from the Data preview box.
9) Click Finish to start the conversion.

That’s it!

❓💬 What other tips do you want to know? Let us know in the comments below.

#HowTech #Excel
--------------------------------------------------------------------------------------------------------------

[IamRoxy]

Thank you, this is exactly what I needed and it worked perfectly!

[isaackebaso]

thank you so much, i need this like yesterday

[danielenenche]

This is so helpful


Can imagine editing 15001 rows of data one by one kudos ❤

[rohansawant]

what to do if there is whole sentence which contain 5 to 6 words & numeric values. how to split that whole sentence text in one row & numeric values seprate

[Techamooz]

If we have a long column, and we want to split that for each 10 data, create a new column. How can we do that?

[maxhbrewster]

I have one column that contains 9 sets of four cells (i.e. 36 rows). How can I convert that one column into 4 columns leaving 9 rows of data?

[kshitijxiaomi]

thank you, what happens when you want to seperate only the first two words and leave the rest, Eg. assuming abcd efgh ijkl are in a single cell
Row 1- abcd efgh ijkl (seperate abcd efgh into two seperate colums, leave efgh ijkl together)
Row 2- lmno pqrs tuvw (same as above)

[simplykmarketing]

You just saved my weekend with this tip! Have 10K names and the CTRL E was not working. THANK YOU!!

[jmbkjr]

I have a 2 columns with data and want transfer the data to 3 columns alphabetically. EG:
Apple

cow 4.15 foxi 2.01



foxi 2.01

[tebqzik_music]

This was not helpful, I looking for option to Split Cell in Multiple cell from a single, Eg F4 cell in want to split the F4 cell in multiple cell in one cell

[MiklaDfar]

This is NOT the correct title. This is splitting DATA.