Combining text cells.

J

johnnyz197034

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!
 
M

Mike

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)
 
Top