View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mahmoud mahmoud is offline
external usenet poster
 
Posts: 5
Default =IF(ISNUMBER(SEARCH("ELB",B2)),"Pipe") add more like "ELB" "FLG"

=IF(ISNUMBER(SEARCH("ELB",B2)),"Pipe")
HOW TO ADD MORE PARTIAL TEXT LIKE "ELB" "FLG" OR MORE PARTIAL TEXT TO THE
SAME FUNCTION