Joining Data of 2 Cells into one cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.?
 
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.?
 
For an actual date/time result:

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

--
HTH,
Laura Cook
Appleton, WI


Steve R said:
Trying to use concatenate function to join cells of 2 different columns
Click to expand...
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.?
 
For a text result, try the following:

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

--
HTH,
Laura Cook
Appleton, WI


Steve R - Correcton said:
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
Click to expand...
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.?
 
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
Click to expand...
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.?
 
Back
Top