Results 1 to 2 of 2

Thread: Find text in one cell and replace with text from another

  1. #1

    Post Find text in one cell and replace with text from another



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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:

  2. #2
    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,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •