Barry,
With Bruce's steps above, I'm not sure I understand what the Column AIt is to contain the combined elements of each member's name & address, in the form: "display name" <user @ example.com> (Ignore the spaces around the @ sign, that's for the benefit of people reading this message on GMF's web pages. Here and below.) My current xls ... has just three columns: A: Last name, B: FirstFor your purpose you could create a column D (or any unused column) containing this expression in each row: =CONCATENATE("""",$B1," ",$A1,""" <",$C1,">") If you enter that in row 1, then copy/paste it to the rest of the rows Excel will automatically update the row number appropriately. If the last name and first name name columns contain no special punctuation characters you could dispense with the "quotes" around the display name field. Comma is a common punctuation mark that would require the use of quotes. For example your list might have an entry like: A: Lastname, MD B: Dr. Firstname C: user @ example.com My expression would build: D: "Dr. Firstname Lastname, MD" <user @ example.com> Column B: Display name is two columns (last name, first name) so notYahoo exported the display name as a single column, unlike your format. You can ignore this. Column D: the delivery option would be fine but not essential for us.Again, information from Yahoo (the member's Email Delivery setting) which you can ignore. ... I'm just hoping that I may have missed a clear checklist or guideIn my example you would copy column D and paste that into the box on the Direct Add page. Direct Add does not accept Excel or csv formats, only plain text. So you'd need to export only column D into a plain text file if you'd prefer to upload from a file rather than use cut and paste. Shal -- Help: /static/help More Help: /g/GroupManagersForum/wiki Even More Help: Search button at the top of Messages list |