Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste Delimited
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving as tab delimited or comma delimited | Excel Discussion (Misc queries) | |||
space delimited files now tab delimited | Excel Discussion (Misc queries) | |||
How can I convert tab delimited files to pipe delimited? | Excel Discussion (Misc queries) | |||
delimited copy and paste | Excel Discussion (Misc queries) | |||
Paste comma delimited text into a spread sheet | Excel Discussion (Misc queries) |