Title: Add space between number and text in a cell in Excel
Headings: Add space between number and text in a cell in Excel
Add space between number and text in a cell in Excel
Add space between number and text – the text always comes first
Generic formula
Arguments
How to use this formula?
=TRIM (REPLACE (B3,MIN (FIND ( {1,2,3,4,5,6,7,8,9,0},B3&"1234567890")),0," "))
How this formula works?
Add space between number and text – the number always comes first
Generic formula
Arguments
How to use this formula?
=TRIM (REPLACE (B3,MAX (IFERROR (FIND ( {0,1,2,3,4,5,6,7,8,9},B3,ROW (INDIRECT ("1:"&LEN (B3)))),0))+1,0," "))
Related functions
Related formulas
The Best Office Productivity Tools
Kutools for Excel - Helps You To Stand Out From Crowd
Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)

Content: And keeps no leading and trailing spaces of the text. Add space between number and text – the number always comes first
Another case as the below screenshot shown, there is a text string list contains number and text where the number always comes first, you can apply the below array formula to add a space between the number and text. Generic formula
=TRIM (REPLACE (text_string,MAX (IFERROR (FIND ( {0,1,2,3,4,5,6,7,8,9},text_string,ROW (INDIRECT ("1:"&LEN (text_string)))),0))+1,0," ")) + Ctrl + Shift + Enter
Arguments
Text_string: The text string you will add space between the text and number. It can be: The text string enclosed in quotation marks; Or a reference to a cell containing the text string. How to use this formula? 1. Select a blank cell (D3 in this case) to output the result.