Extracting Specific Text

I posted a topic similar to this yesterday evening, and received such a fantastic response that I'm back with another question.

So, I have a column full of cells that look like this

Three velvet lilies with bead and sequin centers lie 5" long on a 2 1/2" salon clip. Colors: Black, Blush, Winter White <img src="/PDGimages/swatch-calla-lily.jpg" alt="calla lily swatch" />

Unfortunately, the descriptive text, list of colors and HTML code need to be extracted individually so they can be put in their own column.

Last night I was taught how to remove the HTML by using a formula which targeted the <'s which open and close the code, which worked great. But now, I need to extract from Colors: through that opening carrot, and once it's in its own column have a way to easily delete it from the existing one.

Is this possible?

If your text is in A1, then in B1 enter:

=TRIM(MID(A1,FIND("Colors:",A1),FIND("<",A1)-FIND("Colors",A1)-1))

then in C1 enter:

=TRIM(SUBSTITUTE(A1,B1,""))

Great. If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Try:

=TRIM(MID(A1,FIND("Colors:",A1),IF(ISNUMBER(FIND("<",A1)),FIND("<",A1)-FIND("Colors",A1)-1,255)))