Add comma after first word in a cell in Excel
To add a comma after the first word only in a cell, you can use a combination of the REPLACE and the FIND functions in Excel.
How to add comma after the first word in a cell in Excel?
Supposing you have a list of names as the below screenshot shot, and now you only want to add comma after the surname in each cell, you can do as follows step by step to get it down.
How to use this formula?
1. Select a blank cell such as D3 to output the result.
2. Enter the below formula into it and press the Enter key. And then drag the result cell all the way down to apply it to other cells.
How this formula works?
- 1. FIND(" ",B3): The FIND function returns the starting position of space in text string "Doe Jane A". Here the result is 4, which means that the first space is in the 4th position in "Doe Jane A".
- 2. REPLACE(B3,4,0,","): Here use the REPLACE function to add a comma to the 4th positon in "Doe Jane A" and finally get the result as Doe, Jane A.