Eek, you have to manually clean thousands of addresses out. Sorry! Try pulling the data into CF to parse it and searching for line breaks by looking for ASC(??) or similar, the line return characters are 10 & 13 I believe. You could probably load the file to the server, load a file you make that pulls it in as a long variable and then parses for the line break characters, etc.
Or, you can copy/paste into Excel and then write a macro with if statements that checks just that line. Then copy the line with the formular down for each record. You may find that you have to use 2-3 different methods, each one cleaning it up a bit. ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]
