Thread: IF-MID Function
View Single Post
  #3   Report Post  
ROBERT0803 ROBERT0803 is offline
Junior Member
  
Posts: 3
Default
Quote:
Originally Posted by Spencer101 View Post
Hi,

Does the below formula do what you mean?

=IF(OR(MID(A25,11,2)="EA",MID(A25,11,2)="E6"),MID( A25,11,2),"")
You rock. worked great.
Reply With QuoteReply With Quote