+ Reply to Thread
Results 1 to 3 of 3

Advanced find and replace formula

  1. #1
    Registered User
    Join Date
    07-20-2016
    Location
    Bromsgrove
    MS-Off Ver
    Office 365
    Posts
    39

    Advanced find and replace formula

    Im hoping for some help. Ive attached the first two lines of content from a spreadsheet Im creating.

    In it I have two worksheets.

    The first worksheet is called Main Products and its column AG (title Description) that I want to populate with a unique description.

    In the other worskeet named Extra info I have the unique data.

    Column C is the main bluk of the description which needs to be pulled into the Main products worksheet column AG.

    When its pulled in it needs {{CAR}} from the description to be replaced with the content from column A with the heading of {{CAR}}

    Also {{title}} from the description should be replaced with the content from column E - titled {{title}}

    Finally {{image}} should be repalced with the content from coumn F entitled {{image}}

    I know it can be done but no idea where to start andy help would be really appreciated.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-20-2016
    Location
    Bromsgrove
    MS-Off Ver
    Office 365
    Posts
    39

    Re: Advanced find and replace formula

    There was one more thing I needed to do aswell

    Where we have the line

    <img src="{{image}}" class="img-responsive" alt="" />

    in the description I need to add the content from column E on the Extra info worksheet between the ""

    For example the 1st line would be:

    <img src="{{image}}" class="img-responsive" alt=" Pre cut window tint for front & rear glass of a Alfa Romeo 146 (1995-2001) " />

    and then the {{image}} will be replaced with the url as mentioned above. So for the 1st line of the sheet it would be replaced with:

    <img src="https://www.evowrap.co.uk/wp-content/uploads/2020/04/463f26cd-pre-cut-car-window-tint-alfa-romeo-146-5-door-hatchback-1995-2001-full.jpg" class="img-responsive" alt=" Pre cut window tint for front & rear glass of a Alfa Romeo 146 (1995-2001) " />

  3. #3
    Registered User
    Join Date
    07-20-2016
    Location
    Bromsgrove
    MS-Off Ver
    Office 365
    Posts
    39

    Re: Advanced find and replace formula

    I’m wondering if anyone knows what the function would be to do one of these find and replaces? I think if I can find out how to do one I may be able to do the same thing multiple times and just keep editing the formula to make it work

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Advanced Find and Replace by Column
    By xDimitrius in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-22-2015, 02:08 PM
  2. Advanced replace and find formula help
    By jschleider in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-18-2014, 11:32 PM
  3. Advanced Find and Replace VBA Help
    By Remotruker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-06-2012, 05:27 PM
  4. Advanced Find and Replace
    By lucydear in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2010, 08:58 AM
  5. Excel 2007 : advanced find and replace/apend
    By sip in forum Excel General
    Replies: 9
    Last Post: 07-16-2008, 09:00 PM
  6. Advanced Find and Replace Question
    By Ryan in forum Excel General
    Replies: 3
    Last Post: 08-06-2006, 02:00 PM
  7. [SOLVED] Advanced Find and Replace Question
    By Ryan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-05-2006, 11:00 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1