'REGEX Positive look ahead in REGEXEXTRACT GSheet formula

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 link to my headache

regexgoogle-sheetssyntax


Solution 1:[1]

try in C2:

=INDEX(REGEXEXTRACT(A2:A3; "(?i)([a-z]+$)"))

enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 player0

Related Questions