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