Home OS Windows How to add a Comma after first Word in each Cell in...

How to add a Comma after first Word in each Cell in Excel

It is quite common in randomly compiled lists in Excel that the information is lacking commas after the primary phrase. This is particularly the case when the information is copied from phrase editors. To discover tips on how to add a comma after the primary phrase in every cell, please learn by way of this text.

You can add a comma after the primary phrase in every cell in Excel by two strategies:

  1. Using Replicate operate
  2. Using Substitute operate

There are many formulation so as to add a comma after the primary phrase in a cell. In case you’ve got a listing organized throughout a column, you’ll be able to replicate the system throughout the checklist utilizing the Fill possibility.

Add a comma after the primary phrase in every cell in Excel utilizing Replicate operate

The syntax so as to add a comma after first phrase in every cell in Excel utilizing the Replicate operate is as follows:

=REPLACE(<first cell through which you have to add comma>,FIND(" ",<first cell through which you have to add comma>),0,",")

Where,

  • <first cell through which you have to add comma> is the primary cell within the checklist throughout the column for which you have to add the comma after the primary phrase.

Eg. Let us assume a case the place we have to add a comma after the primary phrase in each cell for a listing of names + sport performed the particular person. The checklist begins from A3 and ends at A7. We want the revised checklist in column B.

The system would turn out to be:

=REPLACE(A3,FIND(" ",A3),0,",")

Add comma after first word in each cell

Enter this system in cell B3 and click on anyplace exterior the cell.

Now click on on cell B3 once more to spotlight the Fill possibility and pull it right down to cell B8. You would get the specified end result.

Add comma after first word in each cell using Replicate function

Add a comma after the primary phrase in every cell in Excel utilizing Substitute operate

The syntax so as to add a comma after the primary phrase in every cell in Excel utilizing Substitute operate is as follows:

=SUBSTITUTE(<first cell through which you have to add comma>," ",", ",1)

Where,

  • <first cell through which you have to add comma> is the primary cell within the checklist throughout the column for which you have to add the comma after the primary phrase.

Eg. We can use the identical instance as earlier the place the checklist of entries begin from cell A3. The system with the Substitute operate would turn out to be:

=SUBSTITUTE(A3," ",", ",1)

Add comma after first word in each cell using Substitute function

Enter this system in cell B3 and once more use the Fill possibility to copy the system throughout the column.

Pull it right down to cell B8 after which click on anyplace exterior the choice.

We hope this resolution was useful!

Add comma after first word in each cell using Replicate function

Most Popular

Intel given greenlight to supply some products to Huawei

(Reuters) — Intel has received licences from U.S. authorities to continue supplying certain products to Huawei Technologies, a company spokesman said...

Molekule launches pro-grade air purifier for businesses

Molekule wants to reinvent air purification and today it is launching its Molekule Air Pro, a professional-grade air purifier for commercial spaces. The demand for...

“No pixel left behind”: The new era of high-fidelity graphics and visualization has begun

Everybody loves rich images. Whether it’s seeing the fine lines on Thanos’ villainous face, every strand of hair in The Secret Life of Pets...

Microsoft’s Bethesda deal will spur more acquisitions and industry upheaval

Microsoft’s $7.5 billion acquisition of ZeniMax Media (the owner of Bethesda Softworks, Id Software, and other studios) will change the gaming landscape, and we’ve...

Recent Comments