combining cells

L

lyneday

how do i combine two cells in two rows into one cell without losing data

for example

A1 information here needs
A2 to be combined with information here
 
J

JMorrell

Two ways that I know of.

if cell B5 has LastName and cell C5 has FirstName try this:
=CONCATENATE(B5,", ",C5)
this gives you "LastName, FirstName"

another way to do it is:
=B5 &", " & C5
this gives the same result.

hth,
JMorrell
 
Top