I have 3 columns e2 month f2 day g2 year 5/15/7
How can I concantenate column e2+f2+g2 to get 5/15/07

thanks.

Do you want the result to be a date? Or text that looks like a date?

To get a date:

=DATE(G2,E2,F2)

To get text:

=TEXT(DATE(G2,E2,F2),"m/d/yy")

HTH,
Elkar


"lschuh" wrote:

I have 3 columns e2 month f2 day g2 year 5/15/7
How can I concantenate column e2+f2+g2 to get 5/15/07

thanks.

You can join each value by using the & to concatenate the text:

=E2&"/"&F2&"/"&G2

or if you want you can do the following:

=DATE(G2,E2,F2)

And then format the for the date format of your choice.
--
Kevin Backmann


"lschuh" wrote:

I have 3 columns e2 month f2 day g2 year 5/15/7
How can I concantenate column e2+f2+g2 to get 5/15/07

thanks.

the =text(date(xxxxx) worked. The first one just gave me what I typed in.
Probably the format in the cell was off. Thank you so much.

"Elkar" wrote:

Do you want the result to be a date? Or text that looks like a date?

To get a date:

=DATE(G2,E2,F2)

To get text:

=TEXT(DATE(G2,E2,F2),"m/d/yy")

HTH,
Elkar


"lschuh" wrote:

I have 3 columns e2 month f2 day g2 year 5/15/7
How can I concantenate column e2+f2+g2 to get 5/15/07

thanks.