Results 1 to 5 of 5

How to locate one number in a string of 17?

Threaded View

  1. 11-30-2009, 12:00 PM #1
    REUBENO
    REUBENO is offline
    Registered User
    Join Date
    11-30-2009
    Location
    FORT MYERS, FLORIDA
    MS-Off Ver
    Excel 2000
    Posts
    2

    Question How to locate one number in a string of 17?

    Good morning all, I hope someone can help me. I am sure that there is a simple formula for this, but i'll be damned if I know it. I have an Excel Spreadsheet with Vehicle VIN #'s in the cells (EG. KGCMH64U90F905165 in cell A1) and I want to be able to have cell B2 pull only the 10th digit in that # (EG. B1=0) or the 5th digit in the # (EG. B1=H). Does anyone know how I can accomplish this?
    Last edited by NBVC; 11-30-2009 at 01:50 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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