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:
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.
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.
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.
And there you go.
The same goes with the text as well.
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
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.
It’s easy, isn’t it?