With Text to Columns has a 'Treat consecutive delimiters as one' checkbox,
so 3 spaces shouldn't matter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"reno" wrote in message
...
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