To do this follow the steps mention below:
5) Calculate "Enable regular expressions in formulas" = ON
- Code: Select all
B1 gets the position of the first non-digit in A1, C1 gets the value of the first part, D1 gets the remaining string.
This does not work with Excel because Excel does not know advanced pattern matching by means of regular expressions.