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