Formating Data

fludan · Feb 4, 2004

Hi
I would like to import a list of phone number (000-000-0000) and a would like to format them to a number (0000000000) is this possible?

Thank
Fran

footbinc · Feb 4, 2004

You could connect a recordset to the imported data then use the Replace function in VBA:

NewPNString = Replace(MySTRING, "-", "&quot

where mystring is the phone number with dashes and NewPNString has no dashes

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Formating Data

fludan

Technical User

footbinc

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor