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

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

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

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

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

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