Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I concatenate two columns when one is in date format?
I am trying to combine two columns using =concatenate. One of them is a
column of dates. When I execute the formula the returned value changes my date into a text number. How do i maintain the date value? |
#2
|
|||
|
|||
Within the CONCATENATE() function, instead of referring to the date
cell alone, refer to it by nesting the TEXT() function. For instance: if your date cell is A1 and you're concatenating it with cell B1, your formula would look something like this: =CONCATENATE(TEXT(A1,"mm/dd/yyyy"),B1) You may need to change the arguments of the TEXT function to fit your specific application. |
#3
|
|||
|
|||
=A1&TEXT(B1,"dd mmm yyyy")
-- HTH RP (remove nothere from the email address if mailing direct) "LauraL" wrote in message ... I am trying to combine two columns using =concatenate. One of them is a column of dates. When I execute the formula the returned value changes my date into a text number. How do i maintain the date value? |
#4
|
|||
|
|||
Thanks, this works perfectly.
"Dave O" wrote: Within the CONCATENATE() function, instead of referring to the date cell alone, refer to it by nesting the TEXT() function. For instance: if your date cell is A1 and you're concatenating it with cell B1, your formula would look something like this: =CONCATENATE(TEXT(A1,"mm/dd/yyyy"),B1) You may need to change the arguments of the TEXT function to fit your specific application. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Columns | Excel Discussion (Misc queries) | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
Cobining more than 30 columns of data with concatenate. | Excel Worksheet Functions | |||
Help with a formula for concatenate and search/find with 3 columns | Excel Worksheet Functions |