Combining Functions To Create Array Formula

[Ryan_Bernal]

Hello.
Good Day!
Just want to know how to combine array formula.
This are my formulas:
1.
=LEFT(A1,4) & (RIGHT(A1,4))
this formula will get only the first 3 string and last 4 string.
EX.
DATA DATA EXTRACTED

JAN 1-15-2010 JAN 2010
JAN 1-15-2010 JAN 2010
FEB 1-15,2010 FEB 2010
FEB 1-15,2010 FEB 2010
FEB 1-15,2010 FEB 2010
MAR 16-31-2010 MAR 2010
MAR 16-31-2010 MAR 2010
APR 1-15-2010 APR 2010
APR 1-15-2010 APR 2010
APR 1-15-2010 APR 2010
APR 1-15-2010 APR 2010
APR 1-15-2010 APR 2010
APR 1-15-2010 APR 2010

2. Second Formula:

{=IFERROR(INDEX($A$2:$A$118,MATCH(0,COUNTIF($AE$1: AE25, $AE$2:$AE$118),0)),"") & LEFT(A23,4) & (RIGHT(A23,4))}

I WANT TO COMBINE THIS FORMULAS SO THAT I CAN DISPLAY FIRST 3 AND LAST STRING OF THE UNIQUE VALUES .

Here is the sample:

Data Display unique values (first 3 and last 4 string)

JAN 1-15-2010 JAN 2010
JAN 1-15-2010 FEB 2010
FEB 1-15,2010 MAR 2010
FEB 1-15,2010 APR 2010
FEB 1-15,2010
MAR 16-31-2010
MAR 16-31-2010
APR 1-15-2010
APR 1-15-2010
APR 1-15-2010
APR 1-15-2010
APR 1-15-2010
APR 1-15-2010

Thanks in advance.

[Rajan_Verma]

if i understand this correctly , you want to have First and Last 4 Characters or Unique value,
see if it works

=Left(IFERROR(INDEX($A$2:$A$118,MATCH(0,COUNTIF($A E$1:AE25, $AE$2:$AE$118),0)),""),4) & right(IFERROR(INDEX($A$2:$A$118,MATCH(0,COUNTIF($A E$1:AE25, $AE$2:$AE$118),0)),""),4)

[Admin]

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)&RIGHT($A$2:$A$14,4)),0)),"")

Array entered.

[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)&RIGHT($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.