Find and replace

Hi

I am struggling with a find and replace issue.
I currently use a csv file, and one of my columns has a bunch of html in it with 2 links.
I am trying to make it so that when in a separate column i paste a new link it replaces the links in the first colum. I figured if had the html with a bunch of capital A''s for instance that i could tell it to look for them and replace it with the link in the other column. I want to do this on separate lines not the entire sheet at once. So each line would have new links in the first column.

Is this possible ?
And is ny description as clear as mud ?

Any help greatly appreciated

thanksyou

Thankyou 6StringJazzer that works great

Is there a way to change the formula numbers quickly

I reffer to

=SUBSTITUTE(X2,"HELLO",J2)

changing the x2 to x3 and j3 to j3.. then x4 to x5 on the next row and so on.

my files have 14000 lines on one and 38000 on another so it would be very usefull to do it automatically, or quickly

thanks

SOLVED IT

Thanks for help

You're welcome! Hopefully you discovered that you can just take the first formula and either copy & paste, fill down, or drag down, and Excel takes care of the rest.

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."