Copying Text Cells
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 |
Copying Text Cells
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 |
Copying Text Cells
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 |
Copying Text Cells
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" |
Copying Text Cells
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. |
All times are GMT +1. The time now is 10:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com