M
mk2
I am importing contact information data from Excel. The phone numbers in the
excel spreadsheet have been entered inconsistently. Here are examples:
(xxx) xxx-xxxx
xxx-xxx-xxxx
xxx/xxx-xxxx
xxx.xxx.xxxx
I am importing into a phone number field with an input mask of:
!\(999") "000\-0000;0;_
My question: What is the easiest and fastest way to import this data? Do I
need to eliminate all of the non-numeric characters [(,),-,/ and spaces]
before I import?
Thanks for your help!
excel spreadsheet have been entered inconsistently. Here are examples:
(xxx) xxx-xxxx
xxx-xxx-xxxx
xxx/xxx-xxxx
xxx.xxx.xxxx
I am importing into a phone number field with an input mask of:
!\(999") "000\-0000;0;_
My question: What is the easiest and fastest way to import this data? Do I
need to eliminate all of the non-numeric characters [(,),-,/ and spaces]
before I import?
Thanks for your help!