| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Join text and 2 dates in A2 column in worksheet
Hi,
Can any one help me to join the following:- Z column AA column AB column AC column ------------- ---------------- ---------------- ---------------- Period: 1-Jun-07 to 29-Jun-07 I want to join the above 4 columns into A2 column like: Period: 1-Jun-07 to 29-Jun-07 I used the below formula, but the date is appearing 39234 in numbers and how to join 4 columns with correct date. =Z1&", "&AA1 Pls help me in this regard Thanks in Advance. Shahzad KSA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Join text and 2 dates in A2 column in worksheet
=Text(Z1,"d-mmm-yy")&" to "&Text(AA1,"d-mmm-yy")
It is hard to tell what is in which column, but change Z1 to be the cell with the first date and AA1 to be the cell with the second date. -- Regards, Tom Ogilvy " wrote: Hi, Can any one help me to join the following:- Z column AA column AB column AC column ------------- ---------------- ---------------- ---------------- Period: 1-Jun-07 to 29-Jun-07 I want to join the above 4 columns into A2 column like: Period: 1-Jun-07 to 29-Jun-07 I used the below formula, but the date is appearing 39234 in numbers and how to join 4 columns with correct date. =Z1&", "&AA1 Pls help me in this regard Thanks in Advance. Shahzad KSA |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Join text and 2 dates in A2 column in worksheet
On Jul 7, 5:14 pm, Tom Ogilvy
wrote: =Text(Z1,"d-mmm-yy")&" to "&Text(AA1,"d-mmm-yy") It is hard to tell what is in which column, but change Z1 to be the cell with the first date and AA1 to be the cell with the second date. -- Regards, Tom Ogilvy " wrote: Hi, Can any one help me to join the following:- Z column AA column AB column AC column ------------- ---------------- ---------------- ---------------- Period: 1-Jun-07 to 29-Jun-07 I want to join the above 4 columns into A2 column like: Period: 1-Jun-07 to 29-Jun-07 I used the below formula, but the date is appearing 39234 in numbers and how to join 4 columns with correct date. =Z1&", "&AA1 Pls help me in this regard Thanks in Advance. Shahzad KSA- Hide quoted text - - Show quoted text - Hi, Tom, Thank you very much for the solution, it is working excellent. Thanks for promp reply. Shahzad |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Join text and 2 dates in A2 column in worksheet
=text(z1,"d-mmm-yy") & " to " & text(aa1,"d-mmm-yy") & keep going....
(or use the comma if you want) wrote: Hi, Can any one help me to join the following:- Z column AA column AB column AC column ------------- ---------------- ---------------- ---------------- Period: 1-Jun-07 to 29-Jun-07 I want to join the above 4 columns into A2 column like: Period: 1-Jun-07 to 29-Jun-07 I used the below formula, but the date is appearing 39234 in numbers and how to join 4 columns with correct date. =Z1&", "&AA1 Pls help me in this regard Thanks in Advance. Shahzad KSA -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Join text and 2 dates in A2 column in worksheet
ps.
If you really wanted "Period: " at the beginning: ="Period: " & text(z1,"d-mmm-yy) & ...... Dave Peterson wrote: =text(z1,"d-mmm-yy") & " to " & text(aa1,"d-mmm-yy") & keep going.... (or use the comma if you want) wrote: Hi, Can any one help me to join the following:- Z column AA column AB column AC column ------------- ---------------- ---------------- ---------------- Period: 1-Jun-07 to 29-Jun-07 I want to join the above 4 columns into A2 column like: Period: 1-Jun-07 to 29-Jun-07 I used the below formula, but the date is appearing 39234 in numbers and how to join 4 columns with correct date. =Z1&", "&AA1 Pls help me in this regard Thanks in Advance. Shahzad KSA -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Join text and 2 dates in A2 column in worksheet
On Jul 7, 5:22 pm, Dave Peterson wrote:
=text(z1,"d-mmm-yy") & " to " & text(aa1,"d-mmm-yy") & keep going.... (or use the comma if you want) wrote: Hi, Can any one help me to join the following:- Z column AA column AB column AC column ------------- ---------------- ---------------- ---------------- Period: 1-Jun-07 to 29-Jun-07 I want to join the above 4 columns into A2 column like: Period: 1-Jun-07 to 29-Jun-07 I used the below formula, but the date is appearing 39234 in numbers and how to join 4 columns with correct date. =Z1&", "&AA1 Pls help me in this regard Thanks in Advance. Shahzad KSA -- Dave Peterson- Hide quoted text - - Show quoted text - Hi, Dave, Thanks for prompt reply, the above code is now working perfectly. Tanks again. Shahzad |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I join 3 separate columns of dates | Excel Worksheet Functions | |||
| Text join formulas working but act as straight text when modified | New Users to Excel | |||
| join text | Excel Discussion (Misc queries) | |||
| Worksheet version of VBA JOIN | Excel Programming | |||
Hybrid Mode
