I just this formula and it seems to add an extra space between the numbers. Is it possible to just have 1 space?
For instance, you have a list of cell contents, each cell contains several words, what your job is to add comma after first word in these cells as below screenshot shown, how can you quickly solve it? In this tutorial, I introduce some tricks to easily handle this problem.
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
To add comma after the first word in a cell, you can apply one of below formulas
=REPLACE(A1,FIND(" ",A1),0,", ")
=SUBSTITUTE(A1," ",", ",1)
=LEFT(A1,FIND(" ",A1,1)-1)&","&MID(A1,FIND(" ",A1,1),255)
Select a blank cell, and enter any one of above formulas, and then drag autofill handle down to apply this formula to cells. See screenshot:
|Kutools for Excel: The 200 functions you must have in Excel, you can free download from here|