New answers tagged

-1


0

try this: =REGEXEXTRACT(B1,"\d+\.?\d+$")*1+REGEXEXTRACT(C1,"\d+\.?\d+$")*1 REGEXEXTRACT part of formula "\d+.?\d+$" does this: \d - match and retun digit from 0 to 9 \d+ - gives one or more digits . - any symbol \. - dot ? - makes previous symbol optional (we use it here to match integers) $ - matches end of string



Top 50 recent answers are included