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