Separate Words in Cell

[Pillepop010]

Hello everybody

First of all: Great Forum. So far I found a lot of super tips and HowTo’s which helped me get a lot of my “Challenges” resolved. But here is something I have no Idea who to get this done and hope somebody can help me.

I have an Excel (2007) sheet in an Format like that

SKU______Product_________________________Price
123-456___BrandA; BrandB; BrandC; BrandD_____100 €

As you can see, there are multiple Products listed

What I’m trying to figure out is a way to separate all Products to get a result like that:
SKU_______Product_____Price
123-456____BrandA_____100 €
123-456____BrandB_____100 €
123-456____BrandC_____100 €
123-456____BrandD_____100 €

Anybody any Idea how this can be resolved?
Any Help would be much appreciated.

Cheers

Pille

[StephenR]

Try this, which puts results in sheet2.

Please Login or Register  to view this content.

[Marcol]

Another macro might be

Takes data from sheet 1 and inserts in sheet 3

Please Login or Register  to view this content.

Hope this helps

[Pillepop010]

Hi StephenR, Marcol

Both of the Macros are working fine; unfortunately I tried to adopt it to the sheet I'm using (didn't think it would be so complicated)…..without any success. So I made a copy of what the Original is an attached it to this post. Its pretty much the same, just little different. Can you please help me again?

So far: many Thanks and much appriciated

Thanks
Pille

[StephenR]

Try this:

Please Login or Register  to view this content.

[Marcol]

Try this

Please Login or Register  to view this content.

Change to suit your sheet names

Hope this helps

[EDIT 1]
Am I in a time warp after the power cut ....
Never saw your post Stephen

[EDIT 2]
I have changed the code to allow for as many countries as you might need