You could create a new row and enter this formula, then copy it down.
(assuming your data starts in A1)

=SUBSTITUTE(A1," ","")

"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