I am currently using:
=IF((K2="Use Landing Page URL Generator Tool"),"Use Landing Page URL Generator Tool",(REPLACE(K2,FIND("XXXX",K2),4,A2)))
For amongst other things, to replace the variable 'XXXX' if the website that is in the cell next to the formula has 'XXXX' in it. It replaced this 'XXXX' with a 6 digit number from a list I have somewhere in the sheet.
How would I add to this formula if I wanted to ALSO replace another variable like 'VVVV' if it showed up in the URL?
The URL I have been using is:
http://www._________________________...x?keycode=XXXX
XXXX has been successfully getting replaced with a 6 digit number.
Now the URL is going to be changed to:
http://www._________________________...e=XXXX&vd=VVVV
What do I add so that XXXX is replaced with the one column of numbers and the VVVV will also be replaced with the separate column of different numbers I have?
Bookmarks