Excel: Find words in a cell

Hi Experts, i desperately need help with a formula here. I have a huge data sheet with a column which has revelevt info in the below format - **Unworkable code removed** i need to extract the below words and then use a vlookup to get what info i need. **Unworkable code removed** Foe ex, the first fig, has a cell with PUB03 in it, i need to extract this above list from the first column. How do i do this?

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

This thread is current as of April 15, 2014.

For more resources for Microsoft Excel