Formula for extracting certain words into different cells - Help Please :)

if someone could help me with this I would be their best friend forever.

When I download details from my online store, the item and item options are all combined in one cell such as this:

Yankees T-Shirt/yr<br><b>Size:</b>&nbsp;Small<br><b>Color:</b>&nbsp;Navy Blue

I obviously have different colors/sizes etc.. for each sale. Since I submit the information to a supplier, they need the color/sizes each in a different cell. So what I'm looking to do is extract data from cell A and put the item in cell B, the size in cell C and the color in cell D. I tried playing around with the IF and Search functions to try to create code combinations and I'm not getting anywhere. Is there an excel genius out there that can help me?

Hi,

in A1 the big string

in B1 to extract names

=TRIM(LEFT(SUBSTITUTE(A1,"/",REPT(" ",1000)),100))

in C1 sizes

=TRIM(LEFT(SUBSTITUTE(MID(A1,FIND("nbsp",A1)+5,1000),"<",REPT(" ",1000)),100))

in D1 to get the colors

=TRIM(RIGHT(SUBSTITUTE(A1,";",REPT(" ",1000)),100))

Hope it helps

It works!!!! You are a god. You literally saved me HOURS of work each week. Happy holidays to you my BFF !!

Ciao,

many thanks for your kind and generous feedback.

Greetings from Florence