Tell us this step by step please as I cannot get Paste to parse.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Go into Data/ Text to Columns, and deselect space as a delimiter. Cancel
at that stage, and you'll hopefully find that the behaviour of your Paste
is back to normal.
--
David Biddulph

"Eric" wrote in message
...
I am working with a large list of addresses that are all in one column.
i.e.
/ 123 Fair Ave Atlanta GA 12345 / all in a single cell. I need to break
these out so they are like this / 123 Fair Ave / Atlanta / GA / 12345
(street/city/state/zip).

I have accomplished this in the past by clicking into a cell cutting out
"Atlanta GA 12345" and pasting in the next cell over, but when pasting
excel
automatically split each piece of data separated by a space into a
separate
cell. This worked perfectly, but I have tried to repeat this methodology
without success. Can't figure it out.

Any thoughts are greatly appreciated.

Thank you