Joining Data of 2 Cells into one cell

[Steve R]

Trying to use concatenate function to join cells of 2 different columns with data of Dates i.e., 02/21/04 and Time i.e., 17:30 and have my result be "02/21/04 17:30" and displayed as such with having the result converted to digits.?

 

[Steve R - Correcton]

I meant for my result to NOT be converted to machine numerics relative to dates/times. Thank You, Steve


Trying to use concatenate function to join cells of 2 different columns with data of Dates i.e., 02/21/04 and Time i.e., 17:30 and have my result be "02/21/04 17:30" and displayed as such WITHOUT having the result converted to digits.?

 

[Laura Cook]

For an actual date/time result:

=A1+B1
format as "m/d/yyyy h:mm"

--
HTH,
Laura Cook
Appleton, WI

Trying to use concatenate function to join cells of 2 different columns

with data of Dates i.e., 02/21/04 and Time i.e., 17:30 and have my result
be "02/21/04 17:30" and displayed as such with having the result converted
to digits.?

 

[Laura Cook]

For a text result, try the following:

=TEXT(A1,"mm/dd/yy")&" "&TEXT(B1,"hh:mm")

--
HTH,
Laura Cook
Appleton, WI

I meant for my result to NOT be converted to machine numerics relative to dates/times. Thank You, Steve


Trying to use concatenate function to join cells of 2 different columns

with data of Dates i.e., 02/21/04 and Time i.e., 17:30 and have my result
be "02/21/04 17:30" and displayed as such WITHOUT having the result
converted to digits.?

 

[Peter Atherton]

Steve

Concatenate is used for text values. Date and time are
numerical values so if date is in A1 and Time is in B1 use
the formula =A1+B1

Regards
Peter

-----Original Message-----
Trying to use concatenate function to join cells of 2

different columns with data of Dates i.e., 02/21/04 and
Time i.e., 17:30 and have my result be "02/21/04 17:30"
and displayed as such with having the result converted to
digits.?