Combining Functions To Create Array Formula

[Ryan_Bernal]

Hi

Assume your data in A2:A14,

In B2 and copied down,

=IFERROR(INDEX(LEFT($A$2:$A$14,4)&RIGHT($A$2:$A$14 ,4),MATCH(0,COUNTIF(B$1:B1,LEFT($A$2:$A$14,4)&RIGH T($A$2:$A$14,4)),0)),"")

Array entered.

Thanks ADMIN. Works perfectly.
Thank you also Rajan_Verma, unfortunately, your formula doesn't work for me.