| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatinate name and date
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concatinate name and date
Try this:
=LEFT(A1,3)&TEXT(A2,"mmddyyyy") This returns: Car07022008 HTH Steve "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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concatinate name and date
And
=UPPER(LEFT(A1,3))&TEXT(A2,"mmddyyyy") returns CAR07022008 -- Kind regards, Niek Otten Microsoft MVP - Excel "Steve" wrote in message ... | Try this: | | =LEFT(A1,3)&TEXT(A2,"mmddyyyy") | | This returns: Car07022008 | | | HTH | Steve | | "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 | | |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concatinate name and date
Thanks guys, and I like the Upper
have a great day "Niek Otten" wrote: And =UPPER(LEFT(A1,3))&TEXT(A2,"mmddyyyy") returns CAR07022008 -- Kind regards, Niek Otten Microsoft MVP - Excel "Steve" wrote in message ... | Try this: | | =LEFT(A1,3)&TEXT(A2,"mmddyyyy") | | This returns: Car07022008 | | | HTH | Steve | | "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 | | |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concatinate name and date
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatinate Formatting | Excel Discussion (Misc queries) | |||
| Concatinate a function and make it work | Excel Discussion (Misc queries) | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| concatinate data | Excel Worksheet Functions | |||
| Concatinate a filename | Excel Discussion (Misc queries) | |||
Hybrid Mode
