Changing one term in a string question

[TOMMY2]

Hi guys,

Doing hundreds of UTM tracking codes and I need some help to shortcut.

Basically the codes are the same across all platforms, but one or more of the terms is different for each campaign.

An example:

https://homelet.co.uk/landlords/ins...x600&utm_content=spiky&utm_campaign=campaignB

https://homelet.co.uk/landlords/ins...1050&utm_content=spiky&utm_campaign=campaignB

https://homelet.co.uk/landlords/ins...x600&utm_content=spiky&utm_campaign=campaignB

https://homelet.co.uk/landlords/ins...1050&utm_content=spiky&utm_campaign=campaignB The codes here would be the same, with the only change 'campaignC' and 'content=hard'. I want to get the sum right, so how would I REPLACE any term with a new term across the entire document. And how would I replace multiple terms?

<colgroup><col></colgroup><tbody>
</tbody>

if anyone can get this right for me I'll pay you!

Thanks.

 

[NeonRedSharpie]

So the "CampaignB" to "CampaignC" is very, very simple. Question though. With the content=hard...will you always be replacing content=spiky or are there other options?

 

[TOMMY2]

So the "CampaignB" to "CampaignC" is very, very simple. Question though. With the content=hard...will you always be replacing content=spiky or are there other options?

On this example the content & campaign will change, everything else stays the same:

https://homelet.co.uk/landlords/insurance-quote/step1?utm_source=adwords&utm_medium=displaynetwork&utm_term=160x60&utm_content=hard&utm_campaign=campaignA

https://homelet.co.uk/landlords/insurance-quote/step1?utm_source=adwords&utm_medium=displaynetwork&utm_term=468x60&utm_content=hard&utm_campaign=campaignA

https://homelet.co.uk/landlords/insurance-quote/step1?utm_source=adwords&utm_medium=displaynetwork&utm_term=200x200&utm_content=hard&utm_campaign=campaignA thanks!

<colgroup><col></colgroup><tbody>
</tbody>

 

[TOMMY2]

On this example the content & campaign will change, everything else stays the same:

https://homelet.co.uk/landlords/insurance-quote/step1?utm_source=adwords&utm_medium=displaynetwork&utm_term=160x60&utm_content=hard&utm_campaign=campaignA

https://homelet.co.uk/landlords/insurance-quote/step1?utm_source=adwords&utm_medium=displaynetwork&utm_term=468x60&utm_content=hard&utm_campaign=campaignA

https://homelet.co.uk/landlords/insurance-quote/step1?utm_source=adwords&utm_medium=displaynetwork&utm_term=200x200&utm_content=hard&utm_campaign=campaignA thanks!

<tbody>
</tbody>

Is this the REPLACE function?

 

[TOMMY2]

or substitute? although I tried this, with error.

=SUBSTITUTE(A2:A200, "Sales", "Cost")