Extracting words which meet certain criteria

[masond3]

Hey guys

I have a situation which I am hoping you guys can help me out with
Aim – Extract every word after: and before , and put them in the appropriate headings

I have attached my desired results in column B – E. To calculate the answer, the heading of the tile is normally just before the :
Meaning the Answer is after the : and before the ,

I hope this makes sense

Looking forward to your response

[alansidman]

I used the text to columns function found in the Data tab of the ribbbon. Parsed using comma and colon. Then deleted the columns containing the headings.

[masond3]

HI alansidman

I didnt even think of that doH!