+ Reply to Thread
Results 1 to 2 of 2

How to extract alphanumeric characters from a cell?

  1. 12-08-2016, 01:40 AM #1
    TECHO
    TECHO is offline
    Registered User
    Join Date
    12-08-2016
    Location
    El Paso
    MS-Off Ver
    2013
    Posts
    0

    Cool How to extract alphanumeric characters from a cell?

    Hello guys!! I have in a cell the following text for example: Order is failed to get sent to ASN.
    ......
    Would you please mail the PO out to Supplier.
    PONUMBER - "IND3620486"
    PRNUMBER - "PR4565559"
    SUPPLIER - "165865:TRANSPORTADORA C.V"
    COUNTRY CODE - MX ...

    ►I have to put in one cell: IND3620486 and in another 165865:TRANSPORTADORA C.V◄
    I have thousands of INDs and hundreds of suppliers.

    Any idea? Thank you very much for your help.
    Reply With QuoteRegister To Reply
  2. 12-08-2016, 01:41 AM #2
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello TECHO,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to extract characters from alphanumeric excel cell?
    By akan529 in forum Excel General
    Replies: 2
    Last Post: 05-22-2015, 02:18 PM
  2. Extract numbers from a alphanumeric cell
    By cpgscotcher in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-01-2013, 04:10 PM
  3. [SOLVED] Separating numeric and alphanumeric characters into the same cell
    By daniel2126 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-07-2013, 02:33 PM
  4. Extract Alphanumeric string from a cell
    By kenny.fsw in forum Excel General
    Replies: 1
    Last Post: 06-12-2012, 04:36 AM
  5. [SOLVED] Extract number that comes before a certain word in an alphanumeric cell
    By Pearla in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-27-2012, 07:13 PM
  6. Extract TEXT from alphanumeric cell
    By rudeboymcc in forum Excel General
    Replies: 6
    Last Post: 10-23-2009, 01:41 PM
  7. Identify non-alphanumeric characters within a cell in Excel
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2006, 05:45 PM
  8. format cell to place colon btw every 2 alphanumeric characters
    By hogsy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-17-2006, 10:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1