View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric D Eric D is offline
external usenet poster
 
Posts: 50
Default If part of a cell is true

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