10-07-2008 09:29 PM
10-08-2008 07:45 AM
Rather than try to recreate the wheel, I would suggest you simply remove formatting from the Excel data. Act! will format phone number when it is imported. If your data is static, then I would use a simple search and replace to find "(", ")", and " " in the column only. If it is formatted by Excel, then I would change the format to "9999999999".