Combining Functions To Create Array Formula

Hello.
Good Day!
Just want to know how to combine array formula.
This are my formulas:
1.

Code:

---

=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:

Code:

---

{=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.

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)

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.

Quote:

---

Originally Posted by 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)&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.