| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivottable does not copy correctly when copying worksheets | Excel Discussion (Misc queries) | |||
| excel form not functioning correctly | Excel Discussion (Misc queries) | |||
| AutoComplete not functioning correctly | Excel Worksheet Functions | |||
| Correctly copy cells with a macro | Excel Discussion (Misc queries) | |||
| When I copy down into the next cell the formula changes correctly. | Excel Discussion (Misc queries) | |||
Linear Mode
