C
charles.kendricks
I sure this is very simple, but I am still a novice at VBA. I need a
function that will strip out all of the special characters from a phone
number field in a table that I had to import from an excel spreadsheet.
In the original spreadsheet phone numbers are stored in the [HomeTel]
field in several ways. I have a query that looks up clients according
to their phone number, and I want to only have to enter the digits for
the phone number in the query. I want the phone numbers in my
[HomeTel] field to store only the numerical digits.
Charles
function that will strip out all of the special characters from a phone
number field in a table that I had to import from an excel spreadsheet.
In the original spreadsheet phone numbers are stored in the [HomeTel]
field in several ways. I have a query that looks up clients according
to their phone number, and I want to only have to enter the digits for
the phone number in the query. I want the phone numbers in my
[HomeTel] field to store only the numerical digits.
Charles