Actually, the cell contains more than "NY" or "CA". One example: The cell has
this text "Cherokee County, IA, Employment (NAICS), Government (Thousands)
" and I would like to be able to test whether this cell contains "IA" word.
The "FIND" function that you are suggesting in VBA appears to work if the
cell only has one text. What happens if you a several other words in the same
cell.

Thanks.



"Jim Thomlinson" wrote:

Find works great for searching a range of cells for Text strings. Seach this
forum for Find and FindNext code. There are piles of it. If you want to test
a single cell then InStr is probably the function that you want. You can also
use Like... Depends on what exactly you want to do.
--
HTH...

Jim Thomlinson


"GreenInIowa" wrote:

Hi,

I have sells which contains states codes, such as NY, CA, IA, etc., and
would like to find those cells containing these codes. I was wondering if
there is a VBA function to test whether the text in a given cell contains,
let say "NY". I just could not find it.

Thanks.