Split text in excel using formula

When working with data and spreadsheets, readability, and structure matter a lot.

It makes the data easier to skim through and work with. One of the best ways to make your data more readable is to split it into chunks so that it is easier to access the right information.

When entering data from scratch, it’s possible to ensure that we structure the data to be more readable.

However, sometimes you need to work with data that someone else has created.

If the volume of the data is very large then it’s usually quite difficult to structure the data’s readability.

For example, you might have got data with a list of names, and you might want to arrange the names in alphabetical order of surnames.

In other cases, you might have got a list of addresses, but want to organize this data properly so you can clearly see how many of the people reside in, say, New York.

The best way to work through the above two problems is by splitting one column into multiple columns.

The new versions of Excel provide a special feature that lets you do that using the ‘Data’ menu.

Let’s see how thi

how do i separate cells in excel

how can i split columns in excel