Oh yes, David meant us to Select not Deselect Space in the text-to-column
dialog
Thank you!
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Eric" wrote in message
...
Within the workbook you are working with, and while the active cell has
any
text in it, (1) go to Text to Columns (2) select delimited (3) next (4)
check
the box for space (5) hit cancel

After you do this, excel should paste anything you copy or paste as space
delimited. To accomplish this you need to double click into the cell
before
you copy or paste. Copying the entire cell will not work.

Hope this helps.

"Bernard Liengme" wrote:

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