Give this a try this...

=IF(ISNUMBER(--SUBSTITUTE(SUBSTITUTE(A1,"ERIC ",""),
" W-SETT","")),"Valid","Not Valid")

Rick


"Eric D" wrote in message
...
When using IF statements, is it possible to return a value if part of the
cell is true.

For example, in B1 there is "ERIC 12345 W-SETT"

I want it to recognize that "ERIC ##### W-SETT" is true. The numbers
change
from day to day, so i need it to just say as long as there are numbers
there
then its true.

Can anyone help?
--
Eric