To understand how to add space between characters and numbers in Excel, we use the below mentioned Data, which is in alpha numeric format. Lets say.. Data is in below format.
If we need only the first part with Text, we can use Array Formula or any other long formula to track 1st Numeric and 1st Text. Initially, we used to use formulas to get the result, but now in excel there is a new concept which is known as Flash Fill. Excel 2013, make all these concept, within a simple Flash Fill.
In the cell, start typing the pattern to get the data.If you need only Number or only Text, you can do this through simple manual input. Write just the numbers and automatically you can see the format in below cells. If you type alphabets then you can see the alphabet format in below cells.
This way you can select Flash Fill. take a look at the bottom screen, No Code, No Formula, only Excel 2013, Flash Fill..
Just few Manual Step..