View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Wildcard character in an "If" statement?

Try this:

=IF(ISNUMBER(SEARCH("1B",A1)),"found","not found")


"ttretta" wrote:

Can I use a wildcard character in an "IF" statement? For example, if any of
the data in a column contains "1B*", I want to return a certain answer. I
tried typing it in that way, and it was rejected. Couldn't find the answer
in Excel help.

Does anyone have the answer?