Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find/Replace or VBA
I have downloaded 600 name address list from web. i'm tryin to parse the
address. an address example is show he 2449 63rd St Vinton 503 W 6th St Vinton 5378 - 29th Avenue Vinton 525 C Ave. W Norway 2414 76 St Watkins There seem to be 5 blank spaces between the last of the physical addr and the start of the city. Find/Replace does not seem to work, the text/col doesn't recognize the 5 spaces. Any ideas? Thx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find/replace | Excel Discussion (Misc queries) | |||
find/replace enters | Excel Discussion (Misc queries) | |||
Find/replace search field defaults | Excel Discussion (Misc queries) | |||
Word Automation - Find/Replace | Excel Discussion (Misc queries) | |||
Find/Replace carriage return & line feed characters in Excel. | Excel Worksheet Functions |