+ Reply to Thread
Results 1 to 4 of 4

extract the value to the right of "/"

  1. 09-27-2015, 07:14 PM #1
    keith740
    keith740 is offline
    Forum Contributor keith740's Avatar
    Join Date
    04-24-2015
    Location
    Racine, Ohio
    MS-Off Ver
    MS365
    Posts
    241

    extract the value to the right of "/"

    Hello Forum!

    needing assistance with formula. This one is pretty straight forward

    i have a column that is pasted and appears as 8/9 (88.9%)

    needing a formula that will extract the value to the right of "/" only. this example would be "9"

    as you will see in attached some occasions there will be a 2 digit value

    so the valu between "/" and "("

    any assistance greatly appreciated!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-27-2015, 07:25 PM #2
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: extract the value to the right of "/"

    Hi,
    AQ18 copied down

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  3. 09-27-2015, 07:27 PM #3
    keith740
    keith740 is offline
    Forum Contributor keith740's Avatar
    Join Date
    04-24-2015
    Location
    Racine, Ohio
    MS-Off Ver
    MS365
    Posts
    241

    Re: extract the value to the right of "/"

    Perfect... THX Richard and ty for quick reply!
    Reply With QuoteRegister To Reply
  4. 09-27-2015, 07:28 PM #4
    quekbc
    quekbc is offline
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: extract the value to the right of "/"

    Try this.

    Formula: copy to clipboard 
    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] EXTRACT TEXT "SHM" or "SHGB"
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-29-2014, 07:57 AM
  2. Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"
    By Jokeman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  3. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  4. Trying to extract "Text" inbetween ":" and ","
    By Paulzr27 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2013, 05:48 AM
  5. Extract value from rows when top row text = "Admin" and "Clin", then calculate the mean
    By jidef in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-22-2012, 09:38 AM
  6. [SOLVED] How to extract "large" and "small" amounts from vlookup
    By okjeep in forum Excel General
    Replies: 14
    Last Post: 05-02-2012, 06:28 AM
  7. vlookup - extract all row data from "master" for the clients listed in "NewSheet"
    By no dice in forum Excel General
    Replies: 5
    Last Post: 09-19-2008, 04:02 PM
  8. How can I extract the digital part, e.g. "23" in "s 23 secs." in all the column cells
    By DXMM2007 in forum Excel General
    Replies: 6
    Last Post: 11-01-2007, 11:56 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