Most valuable professional
  • Hot Topics

Excel Compare List Of Text Stings

Hello everyone - i am hoping someone can please help as this is a manual task so far and I am hoping it can be automated via formula or vba? I have a list of text search strings terms that I need to search in several columns for possible matches(hits). If match is found for any words on the search string then I would like to display them in a new COL so I can filter and take further actions. Here is my example below. Thank you. List to search on Laptop must be retuned for repairs Remove old ID from hard drive Bran07 was on Monitor List for remo Dfat007 is on build report mobile device failur wind2007/x4/4tran

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

This thread is current as of November 3, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel