Most valuable professional
  • Hot Topics

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 5, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel