In Excel 2 columns data into one?
 

I have a spreadsheet with several columns. I have a last name column and a
first name column and I want to merge the last name and first name into one
column instead of two. Help, I can't fugure this out.

Hi
in a helper column
=A1 & " " & B1

--
Regards
Frank Kabel
Frankfurt, Germany

"Kelgal123" schrieb im
Newsbeitrag ...
I have a spreadsheet with several columns. I have a last name column
and a
first name column and I want to merge the last name and first name
into one
column instead of two. Help, I can't fugure this out.

in column c(or whereever) enter =concatinate(a1,", ",b1).
copy down. move new column to desired place. delete or
hide old a and b columns.

-----Original Message-----
I have a spreadsheet with several columns. I have a last
name column and a
first name column and I want to merge the last name and
first name into one
column instead of two. Help, I can't fugure this out.
.