Copying Text Cells

M

MXG

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
 
T

tim m

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

=SUBSTITUTE(A1," ","")
 
T

tim m

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

Marion Löwe

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

Boris

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