First posting; glad I found this.
If I copy a long list of addresses (say, from the Web) arranged in address blocks, like this:
Jack Nicholson
Big Bank Corp.
123 Fourth Street
Second Floor
Chicago, IL 60603
and want to end up with ALL these addresses in columns (all names in Col A, Company in Col B., etc.), how can I do this? To complicate things, some addresses have more rows in the address block than others; I can work that out by sorting the resulting columns and moving the data, unless someone has something very clever in mind.
Alternatively, does anyone know of a commercial product, faily cheap, that will convert addresses into ACT! contact management software format?
thanks!
If I copy a long list of addresses (say, from the Web) arranged in address blocks, like this:
Jack Nicholson
Big Bank Corp.
123 Fourth Street
Second Floor
Chicago, IL 60603
and want to end up with ALL these addresses in columns (all names in Col A, Company in Col B., etc.), how can I do this? To complicate things, some addresses have more rows in the address block than others; I can work that out by sorting the resulting columns and moving the data, unless someone has something very clever in mind.
Alternatively, does anyone know of a commercial product, faily cheap, that will convert addresses into ACT! contact management software format?
thanks!