How to Add Comma After First Word In Microsoft Excel

How to Add Comma After First Word in Microsoft Excel
In this excel tutorial I’ll show you how you can insert after the first word inside a cell. It means you’ll be able to insert a comma after the first word. I’m going to use formula for this one.

I am using excel 2019 for the demonstration and you can use these formulas to do the job on any excel versions. Without further ado Let’s get started.

Here goes the first formula to Add comma after first word only in excel.
=LEFT(A1,FIND(" ",A1,1)-1)&","&MID(A1,FIND(" ",A1,1),255)
With this formula you’ll be able to Add Comma After the Surname or the first word. Change A1 to your preferred cell for accurate result.

Here goes the second formula to add comma in excel.
=REPLACE(A1,FIND(" ",A1),0,",")
This is how do I add a comma between words in Excel.

Here goes the third formula to add comma in excel between names
=SUBSTITUTE(A1," ",", ",1)

These were the ways to insert comma between words in excel. Try to understand these formulas and use them whenever you need. If you follow the procedure in the video you’ll be able to add commas to words easily in excel using formula. So, this is how you add comma in excel.

#StayHome and learn #Excel #WithME
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[benaiah]

Thank you that was so helpful. Updating our band list! Keep up the good work.

[annelorrainemoreno]

The best and most effective video. Thank u!

[Gawr.GrandCross]

Thank you very much man! I was about to type the whole words, you're a life saver ^_^

[satyamsharma]

how to (, ) add after specific space?