In this article we will learn how to add space between character and numbers in Microsoft Excel 2010.
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.
Add8612875835 space1696927498 between930042083 characters4630303906 and3658091258 numbers9947236542 in634569341 Microsoft6085349775 Excel1847152113
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..
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.