Try this
Put your first name in A1 and your last name in B1
=CONCATENATE(A1,B1)
This one will add a comma between cells
=CONCATENATE(A1,",",B1)
"johnnyz197034" wrote:

Can anyone tell me how to combine a group of text cells into one cell for the
purpose of referencing them in a formula later?
Any help is greatly appreciated!