Dear all, How can do that? A1= ABCDEFG B1=CD...

[Etwo_Cargo]

Dear all, How can do that?

A1= ABCDEFG B1=CD Which formula i need to use to have in C1 ABEFG?

if B1=AB, C1 must change automatically to CDEFG.