basically you can't ... and it's not a good idea to merge cells anyway- they
cause problems "down the track" with sorting & filtering & other things.
If you want the text from two or more cells in one, you can concatenate it
using a formula
=A1&" " & B1
will concatenate the contents of A1 and B1 (with a space between) into the
cell with the formula
you can then copy / edit - paste special, values this formula to turn it
into a real value and then you can delete the original fields. But as far
as possible try and avoid "merging" cells.
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.
