Word from A added to B -> C

Hi Guys and Gals!

My first post here, I have been lurking around for years on the excel forum,
just love it, it really helped me a lot over the years, both in college and at my word place.

Today I need your help again!
I couldn't find the answer anywhere online, so here it goes.

a word in column A, needs to replace a word in column B - either put it in C or just replace it in B.

See attached, it will make better sense maybe.

excel.jpg

thank you so much.

Use SUBSTITUTE. Replace the fixed text "replace" with the contents of column A.


Regards, TMS

Hey,

Find the attached for the answer.

try this in C1 :
=SUBSTITUTE(B1,"replace",A1)
copy down

Hope this helps

or, In B1 :
="www."&A1&".mywebsite.com"
copy down

Edit_
if you have "www.replace.mywebsite.com" stored in say D1, then
in B1:
=SUBSTITUTE($D$1,"replace",A1)
drag down

You are welcome !

Please remember to mark the thread as solved if you are satisfied with your solution :
To mark thread "Solved", go to the top of the thread,click "Thread Tools",click "Mark as Solved"

Thanks for the rep.