3 ms·
The regex is perhaps still clearer (and in general more powerful), but that Excel method is a catastrophe, not the way it has to be done. =MID(B1, FIND("-"
by maxerickson 6y ago
The regex is perhaps still clearer (and in general more powerful), but that Excel method is a catastrophe, not the way it has to be done.
=MID(B1, FIND("-",B1)+1, 2)