how do I merge 2 cells in excel without loosing data

W

wimmat

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
 
J

Jess

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top