Or... you could use the 'edit'...'find' and 'replace' to find spaces and
replace them with nothing.

"tim m" wrote:

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