+ Reply to Thread
Results 1 to 3 of 3

Getting info from a cell after the last letter appears...

  1. 01-13-2014, 09:27 PM #1
    swade730
    swade730 is offline
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Getting info from a cell after the last letter appears...

    If you want to extract the numbers from a cell BUT the numbers always start after the last letter...

    How would you write a code to just extract the numbers?

    for example...

    24Macros113

    So after the letter S, 113 should be pulled from the cell.

    Any help would be appreciated.
    Reply With QuoteRegister To Reply
  2. 01-13-2014, 10:00 PM #2
    apo
    apo is offline
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: Getting info from a cell after the last letter appears...

    Hi..

    Try this..
    Please Login or Register  to view this content.
    Try the attached..
    Attached Files Attached Files
    Last edited by apo; 01-13-2014 at 10:03 PM.
    Reply With QuoteRegister To Reply
  3. 01-13-2014, 10:50 PM #3
    mgs73
    mgs73 is offline
    Valued Forum Contributor
    Join Date
    11-26-2012
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    423

    Re: Getting info from a cell after the last letter appears...

    This should do it:
    Please Login or Register  to view this content.
    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. [SOLVED] Want to count the number of times a particular letter appears within a range
    By dwhite30518 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-11-2013, 01:24 PM
  2. [SOLVED] HELP! Need to delete row ONLY if the letter N appears in BOTH column G and H
    By PLEASEHELPASAP in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-02-2012, 07:29 PM
  3. [SOLVED] Formula to count number of times the letter "X" appears in a cell in a column
    By bwing in forum Excel General
    Replies: 5
    Last Post: 07-05-2012, 04:04 PM
  4. [SOLVED] Info box appears when open a spreadsheet
    By polarjaf in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-12-2012, 08:17 AM
  5. [SOLVED] Pulling a Letter from a cell and filling another cell with info
    By nick s in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 11-28-2005, 12:15 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