I need to combine two Excel columns into one.

Question

Level 1

0 points

I need to combine two Excel columns into one.

Specifically I've exported a .csv file from another web app and it has First Names and Last Names in separate columns. I need them combined into a single column which includes both first and last names. I can't seem to remember how to get it come without the delimiter. I've already had to specify which columns to "skip" and other things in the dialogue box brought up when I "Get external data." Any way to do this cleanly?

Thanks in advance,

Dan

MacBook, Mac OS X (10.7.5)

Posted on Aug 16, 2013 3:31 PM

Reply

Answer 1

Aug 16, 2013 5:35 PM in response to dandgann

As Excel in a MicroSoft product, you may get better anwers by going to their forums.

Best of luck.

Reply

Answer 2

May 28, 2014 1:29 PM in response to dandgann

Easiest way, when already in Excel, is to use the CONCANTENATE function in a new column that will then have the combined text of the separate columns...

For example column A has the first name and column B has the last name...

use the following formula in any empty column cell: =CONCANTENATE(A1, " ", B1)

(note added the literal space surrounded by quotes as thats how you would normally see the names.

then you select and copy the formula of the cell (Cmd-C), then select/highlight the rest of the column and paste (Cmd-V) and you're done.

Reply