ExcelBanter - how do i combine columns in excel

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

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

- - how do i combine columns in excel (https://www.excelbanter.com/excel-discussion-misc-queries/1283-how-do-i-combine-columns-excel.html)

psamiam

how do i combine columns in excel

I need to combine two fields (first name) and (last name) to make one feild
name full name

Dave Peterson

=a1&" "&b1
or maybe
=a1&", "&b1

psamiam wrote:

I need to combine two fields (first name) and (last name) to make one feild
name full name

--

Dave Peterson

Rrneri

use the concatenate function...
=concatenate(A1,b1)
or

=A1&b1

-----Original Message-----
I need to combine two fields (first name) and (last name)
to make one feild
name full name
.

All times are GMT +1. The time now is 10:06 PM.