Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colors of columns after sorting data in the supporting table | Charts and Charting in Excel | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Charting Data from Excel | Charts and Charting in Excel | |||
multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
insert data from one excel file into another | Excel Discussion (Misc queries) |