Hi
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.
Hope this helps
Cheers
JulieD
