how do I merge 2 cells in excel without loosing data
 

how to merge two colums?
one contains text rows
the other contains numeric data
without loosing any of the data
this means merging the data also

thanks for your help

Try Debra's nice coverage at her:
http://www.contextures.com/xlCombine01.html

She also provides some examples of how to format the numeric data part when
it's combined with text under the "Formatting Examples" section - scroll
down towards the end of the page
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"wimmat" wrote in message
...
how to merge two colums?
one contains text rows
the other contains numeric data
without loosing any of the data
this means merging the data also

thanks for your help

Put this formula in a third column:

=CELL1&" "&CELL2

Where CELL1 = the first cell you want to merge, eg A1 and CELL2 = the second
cell, eg B1 - NB there is a space between the "s

Hope that makes sense
Jess

"wimmat" wrote:

how to merge two colums?
one contains text rows
the other contains numeric data
without loosing any of the data
this means merging the data also

thanks for your help