On Wed, 7 Nov 2007 13:07:03 -0800, 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

You can use SUBSTITUTE function, e.g. if your original text is in A1, put
=SUBSTITUTE(A1," ","") in destination cell.

Regards,
B.