+ Reply to Thread
Results 1 to 4 of 4

extract numbers from alphanumeric

  1. #1
    Forum Contributor
    Join Date
    01-06-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    118

    extract numbers from alphanumeric

    Hi,


    Please go through the attachment. i want to extract numbers from text by using vba (need sub procedure not function).

    thank you.


    Regards
    shiva
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,626

    Re: extract numbers from alphanumeric

    The most natural would be probably solution using regular expressions
    You can find a lot of examples on this forum (and in the net).
    So would be lovely if you do this lesson yourself (already knowing what to search).


    Notice that your decimal part is on input side sometimes denoted as dot, sometimes as comma (on input side dot could also be thousands separator). And on output side - always as comma.
    Best Regards,

    Kaper

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: extract numbers from alphanumeric

    This does require a Function (from OZGRID). Hope you can use it.

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: extract numbers from alphanumeric

    Bit tricky
    Please Login or Register  to view this content.

+ 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. Extract numbers from alphanumeric
    By pradeep_as400 in forum Excel General
    Replies: 3
    Last Post: 05-18-2017, 11:13 AM
  2. extract numbers in a cell containing alphanumeric data
    By iamreese in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-09-2014, 12:38 PM
  3. [SOLVED] Extract numbers from a string of alphanumeric text
    By Joshdm0716 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-09-2014, 08:28 PM
  4. Extract numbers from a alphanumeric cell
    By cpgscotcher in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-01-2013, 04:10 PM
  5. how do i extract numbers from alphanumeric file name?
    By LonesomeTwin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-08-2011, 06:03 AM
  6. [SOLVED] Function to extract numbers from an alphanumeric cell
    By diana in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-13-2006, 06:00 AM

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