Results 1 to 2 of 2

Thread: Search and replace/insert HTML code into Master File using tags

  1. #1

    Search and replace/insert HTML code into Master File using tags



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

    Hello

    I need ideally a formula that can do the following;


    Example of the cell A3 tag 1FINDandREPLACE


    Step 1: Look within a specified cell (i.e cell A3) and copy the tag in that cell.
    Step 2: Search within cell B2 (B2 contains various text that includes the tags).
    The tag in cell B2 is then to be replaced with the content from cell B3.

    Step 3: Repeat steps 1 & 2 for tags A3 to A9 and MASTER HTML FILE B1 to L1 and more


    This is a simple idea, but unfortunately I have not been able to find the code already in the forums that can do this task?


    Attached is the problem in the excel file.


    I look forward to your suggested formula, orexample.xlsxif a formula is not possible, a macro could be used and any suggestions on the macro code would be helpful.


    Kind Regards
    David

  2. #2
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,461
    Articles
    0
    Excel Version
    2010 on Xubuntu

Posting Permissions

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