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