Most valuable professional
  • Hot Topics

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? Last edited by Peter_SSs; Apr 15th, 2014 at 07:54 AM.

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel