Change the A2 part to

=Left(A2,3)&TEXT(A2,"mmddyyyy")

--


Regards,


Peo Sjoblom

"Don" wrote in message
...
I have a name in cell A1 that I want to choose the first three charactors
and
a date in A2 that I want the format MMDDYY when I concatinate them
together.

A1 = Carlyle High
A2 = 07/08/2008

A3 "=Left(A2,3)&A2
which gives me "Car39637"
but I want "CAR07082008"

I know the date is some julian date when formated as general and I
remember
this being asked before but I can not find.

Any help? Thanks