ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   In Excel 2 columns data into one? (https://www.excelbanter.com/excel-discussion-misc-queries/1412-excel-2-columns-data-into-one.html)

Kelgal123 December 7th 04 03:53 PM

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.

Frank Kabel December 7th 04 04:06 PM

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.



December 7th 04 04:10 PM

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.
.



All times are GMT +1. The time now is 09:44 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
ExcelBanter.com