Hi MXG,
"MXG" wrote:
Help! How can I copy a cell containing a variable length of text, so that the
destination cell omits spacing.
eg. Mrs Smith.....................MrsSmith
Mr Smith......................MrSmith
sorry pls my english. I wish you will understand me.

mark the column or area or don't mark anithing, if you will change the whole
sheet

choose REPLACE , select in the dialog: Replace
write in field "search": 1 blank (space)
don't write anithing in field "replace with"!

Marion

now, choose the button "all replace"