Trouble importing data

  • Thread starter Thread starter Mark Warner
  • Start date Start date
M

Mark Warner

Any one know how to merge two columns of data and retain all the info in
both independent columns? I've got one column of data data (m/d/y) and
another with time (HH:MM:SS) and performing a simple merge won't cut it.
Thanks for any suggestions.
 
Mark,

If they have bona fide dates and times (not text) you can add them. To to
that, a third column could contain = A2 + B2. Copy down. You can now
format this column for both date and time if you wish (Format - Cells -
Number - Date).

Or you permanently add one column to the other. Select one column, Copy,
select the other column, Edit - Paste Special - Add.

If they're text, concatenate them:

=A2 & " " & B2
Copy down.
 
Back
Top