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

Опубликовано: 25 Июнь 2022
на канале: Excel, Word and PowerPoint Tutorials from Howtech

210,894

411

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 [email protected]
✅ Facebook   / howtechtv
✅ Instagram   / howtechprojects
✅ Twitter   / 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 25 Июнь 2022. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 210,894 раз и оно понравилось 411 посетителям.