combining cells
 

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

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



In article ,
"lyneday" wrote:

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

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

"lyneday" wrote:

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