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: 1. Select a blank cell to output the result. In this case, I select D3. 2. Enter the below formula into it and press the Enter key. And then Drag this result cell all the way down to apply the formula to other cells. =TRIM (REPLACE (B3,MIN (FIND ( {1,2,3,4,5,6,7,8,9,0},B3&"1234567890")),0," "))
Notes: In the formula, B3 is the text string cell which you will add space between the text and number; This formula can only add a space before the first number. For example, this formula will change B34C12G45 to B 34C12G45.