Quote:
Originally Posted by ROBERT0803
I need a formula that copies the text into my cell when my =MID(A25,11,2) position is "EA" or "E6" as the value. I need that EA or E6 to copy into the cell. So the formula would look at the MID position...if its EA or E6 then copy, if not then leave it blank. PLease help!
|
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),"")