+ Reply to Thread
Results 1 to 3 of 3

Capture Left and Right string from the Delimiter

  1. #1
    Registered User
    Join Date
    02-16-2015
    Location
    Chennai
    MS-Off Ver
    2013
    Posts
    39

    Capture Left and Right string from the Delimiter

    Hi.

    I am working on one file. I want to capture the string which is left and right of the delimiter "_". I dont want to use the excel inbuilt"text to column" function. Is there any function which can provide me the same result.

    For Example
    in Cell A1 the string is G26879_7896
    I want to get G26879 in one cell and 7896 in another

    Thanks in advance for the help

  2. #2
    Registered User
    Join Date
    01-28-2014
    Location
    Brno
    MS-Off Ver
    Excel 2010
    Posts
    70

    Re: Capture Left and Right string from the Delimiter

    Hi,

    Put this formula to B1: =LEFT(A1,FIND("_",A1)-1)
    and this to C1: =RIGHT(A1,LEN(A1)-LEN(B1)-1)

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,890

    Re: Capture Left and Right string from the Delimiter

    ...unless you want to use the 7986 as a number (it is text that looks like a number); in which case, use: =--RIGHT(A1,LEN(A1)-LEN(B1)-1)
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ 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] truncate a string x characters after a delimiter
    By timmatthews in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-19-2013, 05:56 PM
  2. [SOLVED] Splitting a string into a vertical list based on delimiter?
    By Flabbergaster in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-19-2012, 08:47 AM
  3. Edit text string using delimiter?
    By 508 in forum Excel General
    Replies: 3
    Last Post: 03-14-2009, 06:03 PM
  4. Show Characters Left of Delimiter (,)
    By bdb1974 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-25-2009, 03:33 PM
  5. [SOLVED] find and remove a string of a cell value with comma as delimiter
    By yefei in forum Excel General
    Replies: 3
    Last Post: 02-28-2006, 09:10 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