+ Reply to Thread
Results 1 to 3 of 3

Extract all text from right until first instance of symbol

  1. #1
    Registered User
    Join Date
    08-30-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    6

    Extract all text from right until first instance of symbol

    Morning all!

    I'm having issue with something that I think should be pretty simple.
    I am trying to extract numbers before, in-between, and after two "/" symbols in a serial number.

    In A1 I have serial numbers that follow the example below:

    1/2/3

    Any of these digits can be either single or double (i.e. 10/2/3, 1/20/30)

    The desired result is the following:

    10/2/3
    A 10
    B 2
    C 3

    So far I've managed to get the results for rows A and B to work regardless of number of digits; but I'm having difficulty with getting row C to work.

    For row C, I tried to use
    Please Login or Register  to view this content.
    but the result returns "/3".

    Obviously I don't want the "/" to appear in the result.

    Any help you can offer is greatly appreciated. =)
    Last edited by Daedra; 05-19-2015 at 06:34 AM.

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,915

    Re: Extract all text from right until first instance of symbol

    =TRIM(MID(SUBSTITUTE($A$1,"/",REPT(" ",LEN($A$1))),(ROWS($A$2:$A2)-1)*LEN($A$1)+1,LEN($A$1)))
    Try this and copy towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    08-30-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Extract all text from right until first instance of symbol

    Hi nflsales!

    I've used that formula, and the result I get is the following:

    Scratch that, it does work! I'm just being silly. Many thanks for the help!

+ 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. [SOLVED] Extract Every Instance of Entry to Another Sheet
    By RomanGriffen in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 09-04-2014, 07:42 AM
  2. [SOLVED] Extract numbers before first instance of text
    By pauldaddyadams in forum Excel General
    Replies: 5
    Last Post: 08-12-2014, 07:34 AM
  3. Checking for a symbol then copying text if it symbol is present
    By fedorafreak in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-03-2013, 08:54 PM
  4. Identify a range, pull first instance of a symbol, repeat
    By Jbm444 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2010, 07:01 PM
  5. How to Extract Text Before Second Instance of a Symbol
    By lionsdeal in forum Excel General
    Replies: 2
    Last Post: 08-04-2009, 02:28 PM

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