On Mon, 2 Mar 2009 08:37:29 -0800, Albee
wrote:

I have a huge column of address info. All the info is only seperated by
spaces not comas. Each address is a different length so i cant even split by
using "spaces" because when seperated into seperate columns info does not
match (I.E. adress info straight down in one column, city or state in one
column). I need to have them seperated so I can do a mail merge. Can anyone
help me? Am i going to have to manually seperate each address by comas??

If you can devise an unambiguous rule for splitting your data, it could likely
be implemented.

Is there any consistency in the way entries are made?

Are there zip codes that could be used to do a lookup to determine the city and
state?

Is there also a NAME in with the address info? If so, how is the name
separated from the street?

--ron