To split the texts and numbers which are present in one cell together, it’s an easy job.

Instead of using a formula or going through a bunch of functions, all you have to do is type, drag and click. 

Here’s what you should do:

split the texts and numbers

In the above example, you can observe that there are some entries given under the “irrelevant data” heading. 

Now all we have to do is separate the numeric and non-numeric data from each other from the very cell.

split the texts and numbers

To do the same, what we do is, we jot down the number right in front of the first data entry, the number should be the one which is present in the entry.

Then all we have to do is go to the down right corner of the cell and drag it till the last data.

split the texts and numbers

After dragging the same, all you get is a bunch of “26” number. And a small box in the down right corner which opens a small dropbox. In the same, we have to select the “Flash Fill” option.

split the texts and numbers

And there you go.

The same goes with the text as well.

split the texts and numbers

All you have to do is jot down the text of the first data entry and drag the same to the end of your data

split the texts and numbers

When it’s done, you have to go to the small box given in the down right corner of the last cell and click on “Flash Fill” option.

split the texts and numbers

And BAMMMM!

split the texts and numbers

It’s easy, isn’t it?