Hello Monsell, Sunday, December 23, 2007, 5:37:38 AM, you wrote: msl> Thank you. all the ID's are stored in a group called TEST in the AB. msl> could you please guide me as to how i can take out the addresses from msl> this group, place it in excel sheet, sort out the ID's beginning from msl> the end as TLD's are at the end of the ID?
msl> once this is done, i could simply place the appropriate ID's into its msl> respective group-country wise. msl> thank you for your kind assistance. Try this. Export to a .csv file and open with excel. Choose a new blank column in excel. In the new column use the "Right" function as below. A B C D 1 First Last E-mail 2 Joe Smith [EMAIL PROTECTED] =Right(c2,3) This will then show .ca 3 Fred Jones [EMAIL PROTECTED] =Right(c2,3) This will then show com You can then sort on this new column. -- Stuart mailto:[EMAIL PROTECTED] Using The Bat! v4.0.0.1 (ALPHA) on Windows XP 5.1 Build 2600 Service Pack 2 ________________________________________________ Current version is 3.99.27.2 | 'Using TBUDL' information: http://www.silverstones.com/thebat/TBUDLInfo.html
