Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find/replace
have a listing of 500 mailing type labels downloaded from web. i i want to
parse into columns... problem with the address portion e.g., 123 W Main St Columbus, Oh 46555 18759 W 1700th Rd New Providence, OH 46555 There seem to be 3 spaces between the ending of the street addr and the start of the city as the only consistency in the scheme. i want to try to use find/replace and put delimiter in, then use the text to column. F/replace doesn't seem to recognize more than one space?? Any ideas? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find/replace enters | Excel Discussion (Misc queries) | |||
Find/replace search field defaults | Excel Discussion (Misc queries) | |||
How to find/replace data in column | Excel Discussion (Misc queries) | |||
How to find/replace data in column | New Users to Excel | |||
Find/Replace carriage return & line feed characters in Excel. | Excel Worksheet Functions |