+ Reply to Thread
Results 1 to 2 of 2

phone number extraction - 11 digits

  1. #1
    Registered User
    Join Date
    01-29-2014
    Location
    manchester
    MS-Off Ver
    Excel 2003
    Posts
    1

    phone number extraction - 11 digits

    Hello there, I've come by this forum by searching ways to extract phone number from chunks of text. I've found a few similar thread here but they have not helped my newbie skills, so would really appreciate some help with this.

    I have a field contain text apprx 200 words in each cell. within there are phone numbers - these are of the format 0#### ###### OR 0########## - note both formats start with a zero, contain 11 digits, and the first format has a space in the middle after the first 5 digits.

    so far I have:

    Function parseNum(strSearch As String) As String

    ' Dim strSearch As String
    'strSearch = "RRP 90 AVE DE GAULLE 92800 PUTEAUX 0109781431-0149012126"

    Dim i As Integer, tempVal As String
    For i = 1 To Len(strSearch)
    If IsNumeric(Mid(strSearch, i, 1)) Then
    tempVal = tempVal + Mid(strSearch, i, 1)
    End If
    Next

    parseNum = tempVal
    End Function


    can you help?

    Thanks

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: phone number extraction - 11 digits

    You may try:
    Please Login or Register  to view this content.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Is it possible to make Excel dial a phone number from my smart phone?
    By D_Step in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-19-2013, 06:11 PM
  2. Data normalizing for phone number extraction
    By 2by4 in forum Excel General
    Replies: 1
    Last Post: 05-30-2013, 12:42 AM
  3. Replies: 1
    Last Post: 11-10-2011, 09:02 PM
  4. Replies: 5
    Last Post: 08-02-2011, 03:08 AM
  5. [SOLVED] change ten digits in a cell to include phone # formats
    By Judi Mason in forum Excel General
    Replies: 4
    Last Post: 10-24-2005, 09:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1