Results 1 to 10 of 15

Thread: Extracting Custom Pattern Consisting of Numbers & Text From Alphanumeric String

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 05-23-2013, 12:37 AM #14
    snb
    snb is offline
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    14
    Well it's rather complicated to write concise code for inconsistent data, but in this case:

    Code:
    Function snb_002(c00)
    snb_002 = Join(Filter(Split(Replace(Replace(Replace(c00, "USA", " USA"), "TCI", " TCI"), ".", " . ")), "0"))
End Function
    Last edited by snb; 05-23-2013 at 12:44 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Extract Number From Alphanumeric Text
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 10
    Last Post: 09-11-2013, 10:14 PM
  2. Extracting Specific Line Of Data From Text File Using VBA
    By galang_ofel in forum Excel Help
    Replies: 6
    Last Post: 06-01-2013, 03:24 PM
  3. Extracting Numeric Values From Alphanumeric Text
    By Safal Shrestha in forum Excel Help
    Replies: 3
    Last Post: 03-21-2013, 12:04 PM
  4. Find a text substring that matches a given "pattern"
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 2
    Last Post: 02-10-2013, 06:19 AM
  5. Extract numbers from alphanumeric values
    By tushar.tarafdar in forum Excel Help
    Replies: 3
    Last Post: 09-20-2012, 10:16 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
  •  

Forum Rules