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!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formating Data

Status
Not open for further replies.
fludan

fludan

Technical User
Feb 1, 2002
41
0
0
US
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
 
Sort by date Sort by votes
You could connect a recordset to the imported data then use the Replace function in VBA:

NewPNString = Replace(MySTRING, "-", "")

where mystring is the phone number with dashes and NewPNString has no dashes
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
119
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Delete Data from Field
Replies
1
Views
77
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Sending data to Excel 1
Replies
2
Views
68
TrekBiker
TrekBiker
Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
83
Xavierparkash
Xavierparkash
caykamanj1966
  • Locked
  • Question
Duplicate Records in DataSheet View
Replies
5
Views
117
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top