concatenating two fields in one cell, of which one is a date.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Manuel Murieta - 08 Feb 2007 21:55 GMT

I have two cells:
Cell A2 Today's date is
Cell A3 02/08/2007
I want cell A4 to state: Today's date is 02/08/2007

When I use the formula =CONCATENATE(A2," ",A3) I get the following:
Today's date is 17669

How do I make this state [Today's date is 02/08/2007] in one field?

Reply to this Message

Trevor Shuttleworth - 08 Feb 2007 22:11 GMT

One way:

=A2&" "&TEXT(A3,"dd/mm/yyy")

Or

=CONCATENATE(A2," ",TEXT(A3,"dd/mm/yyy"))

Regards

Trevor

>I have two cells:
> Cell A2 Today's date is
[quoted text clipped - 5 lines]
>
> How do I make this state [Today's date is 02/08/2007] in one field?

Reply to this Message

George Nicholson - 08 Feb 2007 22:12 GMT

=CONCATENATE(A2," ",TEXT(A3, "mm/dd/yyyy"))

>I have two cells:
> Cell A2 Today's date is
[quoted text clipped - 5 lines]
>
> How do I make this state [Today's date is 02/08/2007] in one field?

Reply to this Message

Ron Rosenfeld - 08 Feb 2007 22:15 GMT

>I have two cells:
>Cell A2 Today's date is
[quoted text clipped - 5 lines]
>
>How do I make this state [Today's date is 02/08/2007] in one field?

=CONCATENATE(A2," ",TEXT(A3,"mm/dd/yyyy"))

--ron

Reply to this Message