Merging 2 columns

  • Thread starter Thread starter Mazzie
  • Start date Start date
M

Mazzie

I have exported text messages into Excel. I want to merge the colums
containing the date, time and the message into 1 column so that they show in
date/time order. I can put the date/time in order but the messages don't
relate. Can anyone help me?
 
Do you have date/time in one column and message in another column?

Simple select both columns and then sort on date... both will sort together...

To combine two columns you can have this in C1
=A1 & B1
and copy down or
=A1 & " " & B1
if you want a space between two values
 
Back
Top