Copying Text Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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," ","")
 
Or... you could use the 'edit'...'find' and 'replace' to find spaces and
replace them with nothing.
 
Hi MXG,
MXG said:
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
Click to expand...
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"
 
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
Click to expand...

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

Regards,
B.
 
Back
Top