how do I merge 2 cells in excel without loosing data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top