Thread: Check my IF function
View Single Post
  #6   Report Post  
Gerry-W Gerry-W is offline
Junior Member
  
Posts: 7
Default
This works for me:

=IF(RIGHT(TRIM(A8),3)="ing",A8,IF(ISERROR(FIND("in g ",A8)),"",A8))
Reply With QuoteReply With Quote