The following function will work as long as it's ERIC:

=IF(AND(LEFT(A1,4)="ERIC",RIGHT(A1,6)="W-SETT"),"True",FALSE)

If that's not the case it can still be done with a bit of formula work.
--
Kevin Backmann


"Eric D" wrote:

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