On 29 Dec 2005 14:08:41 -0800, "Harlan Grove" <hrlngrv@aol.com> wrote:
>B2:
>=REGEX.MID($A$2,"([^K]?|.*?((?!FP)..))K",ROWS(B$2:B2))
By the way, I think in keeping with the OP's specifications, this should be:
=REGEX.MID(seq,"([^K]?|.*?((?!FP)..))(K|$)",ROWS(B$2:B2))
I think he always wants the end of the string, even if it doesn't end with a
'K'.
--ron
Bookmarks