Removing Sections of Data From Multiple Cells

**AndianAtWork** · 11-14-2012, 08:25 PM

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+ 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. All systems are vehicle specific and easy to install as durable bolt-on systems. Every REMUS system is EC approved, and TUV and ISO certified unless specified otherwise. 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. 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.

**Pete_UK** · 11-14-2012, 08:34 PM

Try this in U2:

=SUBSTITUTE(T2,LEFT(S2,LEN(S2)-3)&"+","")

then copy down.

Alternatively, also in U2:

=RIGHT(T2,LEN(T2)-SEARCH(" ",T2)+1)

Hope this helps.

Pete

**AndianAtWork** · 11-14-2012, 08:36 PM

That was a very quick reply. Thank you! I'll give it a whirl right now and edit this in a moment with results.

The second one worked like a charm :]

The first one worked great, but for some reason didn't get them all when copied down.

Thank you so much for your help!!