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
--------------------------------------------------------------------------------------------------------------
✅ All our announcements are available here https://t.me/howtechtv
✅ Commercial questions info@howtech.tv
✅ Facebook https://www.facebook.com/howtechtv
✅ Instagram https://www.instagram.com/howtechprojects
✅ Twitter https://twitter.com/howtechprojects

Видео How to Split One Column into Multiple Columns in Excel | How to Use Text to Columns in Excel канала Excel, Word and PowerPoint Tutorials from Howtech