+ Reply to Thread
Results 1 to 3 of 3

Formula to extract number only

  1. #1
    Forum Contributor
    Join Date
    07-16-2012
    Location
    Fort Worth, Texas
    MS-Off Ver
    Excel 2010
    Posts
    378

    Thumbs down Formula to extract number only

    Hello,

    I have list of item numbers which some of them contain letter "C" or "S" at the end. For example,

    8002
    8002C
    8002S
    85555C
    825S

    Is there a way to select number only?

  2. #2
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Formula to extract number only

    will it be a max of one character at the end to remove?
    Please click the * icon below if I have helped.

  3. #3
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Formula to extract number only

    This formula should work if that is the case:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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. Replies: 3
    Last Post: 04-09-2014, 02:37 PM
  2. [SOLVED] Formula needed to extract number
    By MHamid in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-01-2013, 02:43 PM
  3. Excel Formula to Extract a Number from a Cell
    By housinganalyst in forum Excel General
    Replies: 4
    Last Post: 07-29-2011, 11:41 AM
  4. Array Formula To Extract The Most Repetitive Number
    By John Vieren in forum Excel General
    Replies: 3
    Last Post: 08-23-2009, 05:00 AM
  5. extract number and use in formula from text & numbers in cell
    By ivory_kitten in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-14-2006, 12:45 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1