Deleting a "+" from a phone number in Access table...help!

[Crazineko]

Hello all,

I am fairly new to Access and am running into a problem. I am looking at a table that has all phone numbers that have called our business for the month of November. However, many of our numbers that have automatically populated have populated like this in 2003 Access, and this an example of how the column appears:

Incoming Calling Number (Column header)

[phone]
[phone]
2104007083
[phone]
2093212556
[phone]

I have 1500 records, and I am trying to delete the "+"'s and sort the phone numbers A/Z. I have copied this into Excel and deleted the "+" by the find "+" and "replace with nothing" tool. While that deleted the "+", when I tried to sort A/Z I found that Excel sorted the # that were previously "+", and then sorted all the regular numbers separately.
I also tried to do the same in notepad and paste the column back in, but Access couldn't handle the paste and freezed up.

If I could have help with this, I would be very thankful. As stated above, I just started using Access. Please be very descriptive! :)

[Dököll]

I have 1500 records, and I am trying to delete the "+"'s and sort the phone numbers A/Z. I have copied this into Excel and deleted the "+" by the find "+" and "replace with nothing" tool. While that deleted the "+", when I tried to sort A/Z I found that Excel sorted the # that were previously "+", and then sorted all As stated above, I just started using Access. Please be very descriptive! :)

Hey there, have a look here, see if this article saves you, I actually am going to try it for the dash in certain SSNs 000-00-0000. Not too savvy at Access either, I feel your pain. If I get it, I try to explain, not making any promises though so please try yourself ;-)

http://support.microsoft.com/?kbid=210433

[Dököll]

Hey there, have a look here, see if this article saves you, I actually am going to try it for the dash in certain SSNs 000-00-0000. Not too savvy at Access either, I feel your pain. If I get it, I try to explain, not making any promises though so please try yourself ;-)

http://support.microsoft.com/?kbid=210433

Just in case the link no longer works...

 
Function FindTabs(WhichField As String) As String
   Dim intCounter As Integer
   Dim strText As String
   Dim intStart As Integer
 
   intStart = 1
   intCounter = 1
   strText = WhichField
 
   Do Until intCounter = 0
      ' Chr(9) is the Tab character.
      ' Replace Chr(9) with the ANSI code for the character
      ' you are searching for.
      intCounter = InStr(intStart, strText, Chr(9))
      intStart = intCounter + 1
      If intCounter > 0 And Not IsNull(intCounter) Then
         strText = ReplaceTabs(intCounter, strText)
      End If
   Loop
 
   FindTabs = strText
End Function
 
 

Good luck to you!

Dököll