Excel solution needed

I am trying to insert my affiliate id into a url I attach some examples of how the original url looked before converted to affiliate link I want excel spreadsheet to be able to automate this process however sometimes I notice the formulas I put together to attempt to get the same after result as the word document didn't work across all three scenarios shown in the word doc. The formula needs to be able to handle variable changes to length of strings