If Question

[Guest]

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.

 

[Guest]

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))

 

[Guest]

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