Concatinate name and date

  • Thread starter Thread starter Don
  • Start date Start date
D

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
 
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
|
|
 
Back
Top