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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging multiple columns into one column (dynamically) 1
putting a column of names into alphabetical order 1
Merging Two Columns 3
I don't get it... - Merging 2
Mail Merge Problem 3
date and time separation 2
Date format to Text Date for use in Mail Merge 3
how do I remove line breaks from several cells? 6

Back
Top