concantenate text to date
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. |
concantenate text to date
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. |
concantenate text to date
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. |
concantenate text to date
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. |
All times are GMT +1. The time now is 03:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com