Copy & Paste not functioning correctly

C

Charlotte Howard

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
 
R

Roger Govier

Hi Charlotte

Go back into Data>Text to Columns>Delimited> remove the check mark next to
Space
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio shape text disappears upon copy paste 1
Web Page Addresses as In-Text Citations HELP! 2
Copy & Paste 2
Copy and Paste 2007 1
Copy and Past Values AND Formatting AND Text 1
Table Preferred width is changed when pasting 1
Copy text into blank rows 2
Copy paste only working once 2

Top