Community
Showing results for 
Search instead for 
Do you mean 
Reply

Importing phone numbers

Tuned Listener
Posts: 13
Country: Canada

Importing phone numbers

MHere is my problem. I'm trying to import datas from excel (csv) where phone numbers have this format (514) 276-4400 for example. But whenit get into Act last 2 digits are lost. How can I manage this situation ? Thanks
Copper Elite Contributor
Posts: 108
Country: United States

Re: Importing phone numbers

André,

 

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".

 

MrWright

Tuned Listener
Posts: 13
Country: Canada

Re: Importing phone numbers

Great ! Thanks

 

AL : )