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.
Bookmarks