Hello,

I'm hoping one of you can point me in the right direction re a tricky Excel question (at least, it seems tricky to me).

I've got a large spreadsheet of product data which I want to import into an EPOS (i.e. retail) system. One of the columns in the spreadsheet is for "Product Name", and it looks like this:
Product Name
Cult small sticker pack
Fiend snap back cap Black
Fiend snap back cap Khaki
Federal Drop bars Metallic blue 9"
Federal Drop bars Metallic blue 9.25"
Federal Drop bars Chrome 9"
Federal Drop bars Chrome 9.25"
Skull Beanie small
Skull Beanie large

So, some products come in different sizes and colours, some products come in different sizes only, some products come in different colours only, and some products don't come in any such variants.

At the moment, all of that size and colour info is lumped into the "Product Name" column.

Problem is, in order to get the best out of my EPOS system, any sizes and colours need to be seperated out into different columns of the spreadsheet - i.e. they'd need to be split up a bit like this:
PRODUCT NAME COLOUR SIZE
Cult small sticker pack
Fiend snap back cap Black
Fiend snap back cap Khaki
Federal Drop bars Metallic blue 9"
Federal Drop bars Metallic blue 9.25"
Federal Drop bars Chrome 9"
Federal Drop bars Chrome 9.25"
Skull beanie Small
Skull beanie Large

The spreadsheet's over 2000 lines long, so cutting and pasting all this by hand, one row at a time, would take forever.

There's got to be a way to automate this; I image there's a way Excel can be made to scan through the PRODUCT NAME column, and every time it finds a "colour" phrase, cut and paste it into column B, then do something similar with "size" phrases into column C (and presumably I'd need to write a list of what "colour" and "size" values for it to look out for)...

But, I'm damned if I know how to even start going about that.

Can anyone here help?

Thanks in advance