Copy & Paste not functioning correctly
Hello,
I'm trying to separate out some address fields (I can't use text-to-cols as there are huge inconsistencies). When I select a chunk of text, copy, paste, the text is truncated at the first space. ie '1A The Willows River View Road' - If I select 'River View Road', copy, paste into another cell - I only get 'River' How can I stop this! Excel 2003 SP3 |
Copy & Paste not functioning correctly
Hi Charlotte
Go back into DataText to ColumnsDelimited remove the check mark next to Space -- Regards Roger Govier "Charlotte Howard" wrote in message ... Hello, I'm trying to separate out some address fields (I can't use text-to-cols as there are huge inconsistencies). When I select a chunk of text, copy, paste, the text is truncated at the first space. ie '1A The Willows River View Road' - If I select 'River View Road', copy, paste into another cell - I only get 'River' How can I stop this! Excel 2003 SP3 |
All times are GMT +1. The time now is 06:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com