Harlan Grove Wrote:
efang001 wrote...
....
let me just add what i'm working with...
i believe that "most" of the telephone fields are the same number of
fields. Obviously the addresses are not, and this was a concern when
I
posted here.

please see the attached document.
....

Most sensible people never open files from strangers. If you want
help,
put 2 or 3 records IN PLAIN TEXT into a follow-up. Generally, if there
are no clear patterns with which to distinguish address from other
fields, parsing becomes an unavoidably manual process.

that is definately true...but it is a zip file, you can view the
contents, and it is a excel file, and there are no macros.

i'm not a big virus/bug hunter, so, maybe i'm missing something here?

anyways, i'm trying some of these formats and advice, thanks


--
efang001
------------------------------------------------------------------------
efang001's Profile: http://www.excelforum.com/member.php...o&userid=31552
View this thread: http://www.excelforum.com/showthread...hreadid=512463