Excel: Find and extract word

Hi, I have a spreadsheet that I update once or twice a week where I need to extract just the colour from a string of words and then copy that colour across into the cell to the left of it. For example one of the cells has "SD | Quick-Fit Sectional Door - Mediterranean Monument,Wood Grain,2400H,4860W" and I need to extract the word "Monument" from the cell and just copy it. Is anyone able to tell me how I might be able to do it easier than manually having to look through each row? Thanks :)

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of December 05, 2015.

For more resources for Microsoft Excel