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 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

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

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"

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.