+ Reply to Thread
Results 1 to 4 of 4

Extract Text between two hypens

  1. 09-02-2012, 01:15 PM #1
    mvcp007
    mvcp007 is offline
    Registered User
    Join Date
    04-15-2010
    Location
    Bangalore
    MS-Off Ver
    2019
    Posts
    57

    Post Extract Text between two hypens

    Hi Experts,


    I am trying to extract text between two hypes,

    Example cell Text : node=t1.test.com-Global Catalog Access-f43fb8d0

    Forumula Utilized: =MID($A2, FIND("-",$A2)+1, FIND("-",$2))

    Current Result : Global Catalog Access-f43fb8d0ADS

    Expected Result: Global Catalog Access

    Kindest Regards,
    VCP Muthukrishna.
    Reply With QuoteRegister To Reply
  2. 09-02-2012, 01:21 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,353

    Re: Extract Text between two hypens

    =MID(A2,FIND("-",A2)+1,FIND("-",A2,FIND("-",A2)+1)-FIND("-",A2)-1)


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 09-02-2012, 01:31 PM #3
    mvcp007
    mvcp007 is offline
    Registered User
    Join Date
    04-15-2010
    Location
    Bangalore
    MS-Off Ver
    2019
    Posts
    57

    Re: Extract Text between two hypens

    Quote Originally Posted by TMShucks View Post
    =MID(A2,FIND("-",A2)+1,FIND("-",A2,FIND("-",A2)+1)-FIND("-",A2)-1)


    Regards, TMS
    Superb Solution, it worked like a charm!!!
    Reply With QuoteRegister To Reply
  4. 09-02-2012, 01:52 PM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,353

    Re: Extract Text between two hypens

    You're welcome. Thanks for the rep.
    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)

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