+ Reply to Thread
Results 1 to 4 of 4

Array Formula for numeric and alphanumeric ID

  1. #1
    Forum Contributor
    Join Date
    11-10-2012
    Location
    istanbul
    MS-Off Ver
    Excel 2013
    Posts
    297

    Array Formula for numeric and alphanumeric ID

    Explained in attached file how the array formula gives correct and wrong result.
    I need to solve this issue in a same array formula.
    Thanks in advance for any reply and help.
    Please see attached file.

    Best regards,
    turist
    Attached Files Attached Files

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Array Formula for numeric and alphanumeric ID

    Here. I've shorten it.
    Attached Files Attached Files

  3. #3
    Spammer
    Join Date
    02-04-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2013
    Posts
    190

    Re: Array Formula for numeric and alphanumeric ID

    another solution, with a UDF function
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    11-10-2012
    Location
    istanbul
    MS-Off Ver
    Excel 2013
    Posts
    297

    Re: Array Formula for numeric and alphanumeric ID

    Dear zbor and Jean.P28
    Thanks for prompt reply and great solutions(formula and macro)
    Regards,

+ 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. [SOLVED] convert Alphanumeric Value into Numeric Value in new column
    By topaz99 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-16-2013, 04:36 PM
  2. [SOLVED] Extracting Numeric data from alphanumeric
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-06-2013, 03:23 AM
  3. Sorting numeric and alphanumeric normally
    By SoTM in forum Excel General
    Replies: 6
    Last Post: 12-16-2012, 06:01 AM
  4. [SOLVED] Sorting numeric and alphanumeric data
    By scokaw in forum Excel General
    Replies: 7
    Last Post: 08-21-2012, 09:00 AM
  5. [SOLVED] IF conditon on numeric and alphanumeric
    By emina002 in forum Excel General
    Replies: 5
    Last Post: 06-13-2012, 04:34 AM
  6. How to ignore alphanumeric (non-numeric) input
    By tek0011 in forum Excel General
    Replies: 6
    Last Post: 11-16-2011, 12:17 PM
  7. [SOLVED] Converting Alphanumeric numbers to Numeric
    By Lowkey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-08-2006, 06:30 PM
  8. [SOLVED] How to change alphanumeric to numeric
    By borg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-12-2006, 07:00 PM

Tags for this Thread

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