ExcelBanter - Excel Spreadsheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel Spreadsheets (https://www.excelbanter.com/excel-discussion-misc-queries/200036-excel-spreadsheets.html)

Janmar

Excel Spreadsheets

Is it possible to merge columns in Excel. Eg. Column A - first name, Column
B - last name. And merge to have full name.

AKphidelt

Excel Spreadsheets

You can't merge the columns but you can concatenate the strings.
In column C type in

=A1&" "&B1

You can add a comma between the " also to separate the names

Then copy and paste that formula

"Janmar" wrote:

Is it possible to merge columns in Excel. Eg. Column A - first name, Column
B - last name. And merge to have full name.

All times are GMT +1. The time now is 02:38 AM.