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