Lists and masks
 

Does any one have information on creating masks for
searches on lists. I always run across .TXT lists and need
to import them into Excel to create a table for mail
merges. Now these lists have addresses and telephone
numbers and are not necessarily delimited by any specific
character. I would like to create a macro or wizard that
can delimit these lists...I.E a mask for email address, a
mask for an international telephone #.

Lists and masks
 

Chip Pearson has some code for opening a text file and reading it in.
http://www.cpearson.com/excel/imptext.htm

But you'll have to come up with the rules for parsing your data. Chip has an
example of extracting first/last names from a cell on a worksheet at:
http://www.cpearson.com/excel/FirstLast.htm

You can see what kind of contortions he went through just to get a few fields.

Good luck,


Colin wrote:

Does any one have information on creating masks for
searches on lists. I always run across .TXT lists and need
to import them into Excel to create a table for mail
merges. Now these lists have addresses and telephone
numbers and are not necessarily delimited by any specific
character. I would like to create a macro or wizard that
can delimit these lists...I.E a mask for email address, a
mask for an international telephone #.

--

Dave Peterson