Lesson#84: Separate text in different columns easily

Lesson#84: Separate text in different columns easily

84-1

Here I will discuss a very useful feature Text to Columns. We can use this feature to split the data into cells throughout the column and split it into many columns very easily. In the above picture, we can see I have some similar types of texts in cells throughout the columns.

84-2

Select the column and go to DATA> Text to ColumnsĀ 

84-3

There you will get a window like the above picture. Select Fixed Width and click on Next.

84-4

Then click on the area where the arrow has been shown in the above picture to create a break line. Click Next.

84-5

Now click Finish.

84-6

See you are all set and a single column has been divided into many columns. I will discuss more on this feature in my upcoming posts.

See also  Lesson#42: Tricks to color alternate rows or columns of the entire sheet at once

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Leave a Reply

Your email address will not be published. Required fields are marked *

*