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: 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. 2. Enter the below formula into it and then press the Ctrl + Shift + Enter keys simultaneously. =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," "))
3. Select the result cell, and then drag it all the way down to apply the formula to other cells as the below screenshot shown. Notes: