Is there a way I can merge data in two cells? I have a file that has the first name and last name in two different cells. I need to import the file into a different system but that system needs the first and last name in one cell.

http://office.microsoft.com/en-us/excel/HP...rgeCellContents

Ok, here ya go:

Let's say in A1 it says "FIRST", and in B1 it says "LAST".

If you want cell C1 to say "FIRST LAST", type in the following: =(A1&" "&B1)

If you want cell C1 to say "FIRST, LAST", type in the following: =(A1&", "&B1)

If you want cell C1 to say "LAST, FIRST", type in the following: =(B1&", "&A1)

Apply it to whatever cells you're using in your case.


ETA: Oops, Dan beat me to it.

Yours is better - no extra clicks needed :-)

Use =CONCATENATE()

And then cut and paste special the values only.

Thank You Everyone!

How about separating data?

I'm trying to get this into five different cells

Name|Email|Format|Encoding|Mailing Groups

You can do a "text to columns" (it is in the dropdown under "data")You can do a "text to columns" (it is in the dropdown under "data")

I'll try it tomorrow, thanks for your help....

Text to columns was one of my favorite discoveries in Excel. It saved a lot of =right(D7,3), =left(A1,6).

It worked, many thanks.....