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.