Results 1 to 4 of 4

Removing Sections of Data From Multiple Cells

Threaded View

  1. #1
    Registered User
    Join Date
    05-11-2012
    Location
    AZ
    MS-Off Ver
    Excel 2003
    Posts
    15

    Removing Sections of Data From Multiple Cells

    I'm not sure what function or Macro would be useful, but here it goes:

    I've got about 1200 rows of product information. We recently updated our formatting, and so now I have to go back through and change the titles. Mind you, everything is different title wise.

    For example: [I was going to post a sample book, but all the data being posted into the new book was cut short, sorry]

    In Column S is the updated Title that will be seen on a webpage:

    Square Quad Tip Complete System Mercedes CL500 5.0L W215 00-06




    Column T is where the title and product description come together on the main part of the page:

    Square Quad Tip Complete System Mercedes CL500 5.0L W215 00+<br><br>Ranked number one in the world, Austrian manufacturer is ahead of the game with their top of the line exhaust systems. At COMPANY, an exhaust is not simply built and put on the market. Each setup is rigorously tested not just for optimum performance, but for the highest quality sound attainable. If they are not perfect, the system is re-engineered and tested until the perfect balance between performance and sound is achieved. Every exhaust system is crafted from only the finest aluminum and steel, giving it the durability necessary to stand up to the rigors of various driving styles. <br><br>All systems are vehicle specific and easy to install as durable bolt-on systems. <br><br>Every REMUS system is EC approved, and TUV and ISO certified unless specified otherwise. <br><br>Fits Mercedes CL500 5.0L W215. Includes four square tips measuring 3.54"x2.95". This exhaust has two pipes: one for the left and one for the right side. <br><br>This exhaust only fits as a complete system!


    What is highlighted in BLUE is what needs to be removed so it can be replaced [I'm using a simple CONCATENATE for that]. So everything before the page breaks [<.br><.br>]

    Any help would be appreciated. This will take forever by hand.
    Last edited by AndianAtWork; 11-14-2012 at 08:41 PM. Reason: solved

Thread Information

Users Browsing this Thread

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

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