+ Reply to Thread
Results 1 to 4 of 4

Replacing specific text in a cell by row and replace with text in another row

  1. #1
    Registered User
    Join Date
    02-23-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2013
    Posts
    31

    Unhappy Replacing specific text in a cell by row and replace with text in another row

    As part of my online store i have to create a CSV file with my store listings. the problem is that it takes a very long time to manually go row by row adjusting my HTML code in one of the columns. basically i have an HTML code in a row A1 that reads as the following

    PHP Code: 
    <h1 style="text-align: center;"><span style="color: rgb(0, 0, 128);">             Cnet 8 Port 10/100 Switch</span></h1><h1 style="text-align: center;"><span style="color: rgb(0, 0, 128);"></span><span style="color: rgb(0, 0, 128);"><img width="500" alt="" src="http://www.imagewarehouse.com/images/image1.jpg"></span></h1>;<strong>  <em><span style="color: rgb(255, 0, 0);"><strong class=" PIN_1373048337377_hazClick"
    My second row B1 reads

    http://www.imagewarehouse.com/images/cnet8port.jpg

    what i need is basically to change "http://www.imagewarehouse.com/images/image1.jpg" to what ever is in row B1. i have roughly 4000 rows with various html code as above but only this sections needs to change. is it possible? PLEASE HELP

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Replacing specific text in a cell by row and replace with text in another row

    Try putting this into C1

    =SUBSTITUTE(A1,"http://www.imagewarehouse.com/images/image1.jpg",B1)
    Martin

  3. #3
    Registered User
    Join Date
    02-23-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2013
    Posts
    31

    Re: Replacing specific text in a cell by row and replace with text in another row

    Quote Originally Posted by mrice View Post
    Try putting this into C1

    =SUBSTITUTE(A1,"http://www.imagewarehouse.com/images/image1.jpg",B1)
    AWESOME!!!!! Thanks mrice....worked like a charm.you da man!!!!
    Last edited by merQrey; 02-23-2014 at 09:57 AM.

  4. #4
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Replacing specific text in a cell by row and replace with text in another row

    Can you provide an example of the sheet as opposed to just a description?

+ 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. Replies: 2
    Last Post: 08-05-2013, 07:32 PM
  2. Look up text in a cell and replace with pre-defined text from a database.
    By AntonNortje in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-10-2012, 03:55 AM
  3. [SOLVED] Formula with specific text that inserts value from BESIDE cell with specific text.
    By jtmann in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-13-2012, 09:24 AM
  4. Replacing specific text in cell
    By SSB in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-22-2012, 01:57 PM
  5. Advanced find and replace specific text within a cell
    By visionwindowfilms in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-14-2011, 04:28 AM

Tags for this Thread

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