Home > The Newbie Zone > Questions and Answers

Any Excel experts here who can help me create a workbook that fixes affiliate links? (5)

10-21-2017 03:01 AM #1 inferno272 (Member)
Any Excel experts here who can help me create a workbook that fixes affiliate links?

on a few of my networks (most?) i have to alter the default link with stuff..it gets time consuming...i would love it to just copy and paste the link into cell A and then have Cell B be a fixed version of that.

For example...

In cell A: http://www.offer.com/blah?something=...hingelse=DATA2
and have it spit out...
http://www.offer.com/blah?something=...IMPORTANTSTUFF

is this possible?

I suck at excel, but I would assume this would be relatively simple?

10-21-2017 06:23 AM #2 DarinaRainmaker (Member)

Hello inferno,

How does DATA become IMPORTANTSTUFF ?

Can the SUBSTITUTE() function help ?
Something like B1 = SUBSTITUTE(A1;"DATA";"IMPORTANTSTUFF";1) ?


Darina

10-21-2017 02:13 PM #3 inferno272 (Member)

Quote Originally Posted by DarinaRainmaker View Post
Hello inferno,

How does DATA become IMPORTANTSTUFF ?

Can the SUBSTITUTE() function help ?
Something like B1 = SUBSTITUTE(A1;"DATA";"IMPORTANTSTUFF";1) ?


Darina
that worked perfectly, though the syntax isnt correct..but thanks...

so if you have "helloworld" in A1 you can have A2 read
=SUBSTITUTE(A1, "hello", "goodbye")

and you'll get "goodbyeworld"

so that should work for what i need. Thanks Darina!!!

10-23-2017 09:17 AM #4 DarinaRainmaker (Member)

Quote Originally Posted by inferno272 View Post
that worked perfectly, though the syntax isnt correct..but thanks...
The syntax changes in Excel with different languages, which never made sense to me but that's how it is..

Quote Originally Posted by inferno272 View Post
so that should work for what i need. Thanks Darina!!!
You're very welcome, happy to help


Darina

10-23-2017 02:15 PM #5 inferno272 (Member)

btw this is worked fantastic..i suggest people do this (unless they have some other way of fixing affiliate links...

mine always have crap like "REPLACE" or what not that i have to edit..so its nice just copying, pasting and then recopying a fixed link back into Voluum.

Home > The Newbie Zone > Questions and Answers