Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |