3 ms·
yeah, that was completely out of left field as compared with =SUM(CODE(MID(LOWER(SUBSTITUTE(SUBSTITUTE(C3,”:”,””) which, while convoluted and a terrible formula
by emeril 2y ago
yeah, that was completely out of left field as compared with =SUM(CODE(MID(LOWER(SUBSTITUTE(SUBSTITUTE(C3,”:”,””) which, while convoluted and a terrible formula/method to use when sharing spreadsheets with others, is far more nuanced