Home > Software engineering >  REGEX Positive look ahead in REGEXEXTRACT GSheet formula
REGEX Positive look ahead in REGEXEXTRACT GSheet formula

Time:03-22

I have a STRING which can contain 1 or more numbers. Same situation for words. I'm look for 2 uniques REGEX formulas (GSheets REGEXTRACT or MATCH compliant)

String : "4 x 120g" OR "120g"

(desired) results :

Last number : 120
Last word : g

Here is a enter image description here

  • Related