combining cells

[Guest]

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

 

[JE McGimpsey]

using a helper cell

=A1 & A2

Copy and Edit/Paste Special/Values back into a1

Via macro, one way:

http://www.mcgimpsey.com/excel/mergedata.html

 

[Guest]

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