If Question

C

carl

How do I put this into an excel formula ?

If this "MID(N3;6;3)" equals "OLA" then do this "MID(N3;6;3)&LEFT(N3;3)"

otherwise

Y3&MID(N3;6;3)

Thank you in advance.
 
T

tim m

Can't really check this without knowing what your data looks like but see if
this works.

=IF(MID(N3,6,3)="OLA",MID(N3,6,3)&LEFT(N3,3),Y3&MID(N3,6,3))
 
Top