Find text in one cell and replace with text from another

RobMoran

New member
Joined
Mar 11, 2015
Messages
1
Reaction score
0
Points
0
I have searched hundreds of forums and can't seem to find an answer to this problem:

I use excel to upload product feeds to several market channels. My description column has 1000s of characters of html data that serves as a template (I placed a snippet of the HTML in column B). Is there a way to:

Replace a text string (Item Title) in column B with the text of column A (Earring)?

A B
Earring "font-size: 24px;">Item Title</span></div><div style="width: 82%25; margin:
 
Good morning,

If you are replacing all instances of "Item Title" found in B, with whatever is in A, you can use:

=SUBSTITUTE(B1,"Item Title",A1)

If it is more complex, this will have to be added to, but it should at least be a start.

Hope this helps,
 
Back
Top