3 ms·
Regular expressions in formulas. (Preferably Perl-style.) Golfing around with LEFT and MID and LEN and RIGHT gets old after a while, and I believe that regular
by qiqitori 4y ago
Regular expressions in formulas. (Preferably Perl-style.)
Golfing around with LEFT and MID and LEN and RIGHT gets old after a while, and I believe that regular expressions are much easier to explain to someone than the aforementioned nested formulas. (I have some Excel teaching experience.) Not just matching, regex string replace too.
Also, there's always room for adding new options when importing CSVs!
- harperlee 4y agoBest to document the steps with intermediate LET expressions.