Concatinate name and date

[Don]

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

 

[Steve]

Try this:

=LEFT(A1,3)&TEXT(A2,"mmddyyyy")

This returns: Car07022008


HTH
Steve

 

[Peo Sjoblom]

Change the A2 part to

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

--


Regards,


Peo Sjoblom

 

[Niek Otten]

And

=UPPER(LEFT(A1,3))&TEXT(A2,"mmddyyyy")

returns CAR07022008

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| Try this:
|
| =LEFT(A1,3)&TEXT(A2,"mmddyyyy")
|
| This returns: Car07022008
|
|
| HTH
| Steve
|
| | >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
|
|

 

[Don]

Thanks guys, and I like the Upper

have a great day