Results 1 to 9 of 9

Extract unique value from number

Threaded View

  1. #1
    Registered User
    Join Date
    06-25-2014
    Posts
    4

    Extract unique value from number

    I have a different type of data in a particular cell..
    Ex:
    Good books ltd 004bm14356890001 Mauritius.

    Now i have to extract the unique no of 16 digits.

    Now few things...
    I have such data approx 50000 rows..
    .unique number can appear anywhere in the data, either in beginning or middle or at the end.....
    The unique number can begin with any number or text....

    Common thing is 16 digit length....


    Please provide me a formula to get the result.

    I have tried
    =if(A2,Find("00", A2),16)

    This formula is limited to beginwith condition. Please advise if this possible to avoid this.


    Sent from my GT-I9082 using Tapatalk
    Last edited by FDibbins; 12-04-2014 at 12:47 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] If Statements (?) - If Cell1 =yes then give -Cell2, If Cell1=no then give +Cell2
    By KTXD in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-02-2012, 12:24 AM
  2. IF give or take
    By lky2k23 in forum Excel General
    Replies: 7
    Last Post: 10-21-2011, 09:25 AM
  3. Give RELEVANT responses to questions. DO NOT give usless list
    By pmartin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-06-2006, 02:00 PM
  4. Give help
    By heinze22 in forum Excel General
    Replies: 2
    Last Post: 04-26-2006, 09:55 AM
  5. I give up! Help Please...
    By Dino in forum Excel General
    Replies: 11
    Last Post: 06-01-2005, 11:29 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