Results 1 to 10 of 10

using regular expressions to get rightmost characters

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-19-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2007
    Posts
    140

    using regular expressions to get rightmost characters

    Hey all,

    I have this:

    =REGEX.MID("\w{1,}\s+&\s+\w{1,}(\s\w{1,})*\s+&\s+",TRIM(A10))

    And I am trying to extract this:

    JANE F

    From this:


    DUBISKY & DONALD J & JANE F

    It currently gives me an empty cell.

    Thanks for a regular expression solution.
    Last edited by johnmerlino; 01-16-2011 at 02:57 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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