VBA for extract #s from diff. strings of data

[juniperjacobs]

I'm attaching an example. column A shows what the data looks like, it will always start in A12 (if that makes a difference), and B and C show what I need from the random string of data in A. I tried text to column and what happens is that for column B i always get stuck with the "S:" and in column C i always get stuck with the color description after the 3-digit color code.

I feel like i need coding or possibly a mega formula, but i'm having trouble, please help.

the style # will always come after the "S:" but sometimes it will be 6 digits, and sometimes 7, and the color code will always be 3 digits.

[DonkeyOte]

Formula wise - perhaps:

Please Login or Register  to view this content.

[Marcol]

Try this workbook, the formula in C12 is dependant on the formula in B12

[juniperjacobs]

can i just say, this site and its helpers never cease to amaze me, thanks all, problem solved w/ both solutions!