Search a string for a specific text value from cells

I have a list of information in column A of a worksheet. I want to check each cell, to see if it is contained within a string, and if so display a msg box"found"

Originally Posted by FDibbins

without seeing what you are working with...try =if(isnumber(search()),"Found",""), copied down

Attached a sample workboot. I need to search, Sheet1 column A, and go row by row checking if the text value found there is found within a predefined string.

Please Login or Register  to view this content.

ConnectorNum is a string that I am searching in. It is defined earlier. This above code doesn't work however, I get type mismatch on the testvalue line..

Any ideas?

Few errors

Please Login or Register  to view this content.

Originally Posted by AB33

Few errors

Please Login or Register  to view this content.

This is helpful, thanks! I got it to work.