How To Tips & Tricks

Excel: Combine two columns

While analysing an Excel sheet the other day, I needed to combine two columns so that I could get names in the format firstname lastname (the list had been provided as lastname,firstname). As it happens, doing so is relatively easy. You do it on a cell by cell basis, by using basic excel commands.

  • If you simply want to combine two columns: =B4&C4
  • Combine two columns with a space between them: =B4&" "&C4

You then copy the command and paste it into the rest of the cells you want to apply it to, and you should see it change the numbers for each row.

By posting a comment, you consent to our collecting the information you enter. See privacy policy for more information.

This site uses Akismet to reduce spam. Learn how your comment data is processed.