
replace Sales for Quarter 2 Product 1 to Sales for Quarter 2 Product 1.

Say, you want to replace only the first occurrence of 1 with 2 i.e. You can use the function =SUBSTITUTE(A2,”1″,”2″) In cell A2, you have the text – “Sales for Quarter 1 Product 1” and you want to replace it with the text “Sales for Quarter 2 Product 2”. Let’s work on an example to understand this function in depth. Using instance_num argument in SUBSTITUTE function
#Insert comma excel formula how to
Now that you are confident in using the SUBSTITUTE function to add comma in Excel between names, let’s move forward and understand how to use instance_num argument in your formula. This will easily substitute a space between names with a comma followed by space. Note that all of the names are now changed to having your needed commas: STEP 3:Do the same for the rest of the cells by dragging the SUBSTITUTE formula all the way down using the left mouse button. We want to replace it into the comma followed by a space, so type it in: =SUBSTITUTE (C9, ” “, “, “) Which text/characters do we want to replace it with? We want to change the space so type it in: =SUBSTITUTE (C9, ” “, Which text/characters do we want to replace? Reference the cell that contains the text or value: =SUBSTITUTE (C9, Which cell do we want to make changes to?

STEP 1:We need to enter the SUBSTITUTE function next to the cell that we want to clean the data from: =SUBSTITUTE I explain how you can do this and please go this tutorial on how to add comma in Excel between names:įollow the steps below to understand how to add comma in Excel between names: The SUBSTITUTE formula is able to do this for us! We want to replace the space with a comma followed by space. In our example below, we have a list of names. Turns out, the SUBSTITUTE formula in Excel would have done this task very easily!
