Add Space Between The Number And Text Excel

 Add values in column A1 then in select B1 and add this fomula to the formula bar marked in Red then press enter.

Now while holding left click (marked in green) then drag down to include all cells with updated formulas 

You should now see the numbers seperate from the text.