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