You've got Excel skills? Let's see.
This month's challenge is in response to a genuine need. This isn't some academic exercise in convoluted Excel formulae, but a real problem looking for a real solution.
Here are the usual rules.
Create a single formula to extract only the numerals from the contents of cell A1. For example, if A1 contains the string "1234ABC567", then the formula needs to return only 1234567.
Have fun
This month's challenge is in response to a genuine need. This isn't some academic exercise in convoluted Excel formulae, but a real problem looking for a real solution.
Here are the usual rules.
- Create a single Excel formula to solve the stated problem.
- The shortest formula wins (when calculating the length of the formula there's no need to include the leading "=", or the curly braces that Excel uses to represent array formulae).
- The formula's number format can be set to whatever you want.
- Conditional formatting is not allowed.
Create a single formula to extract only the numerals from the contents of cell A1. For example, if A1 contains the string "1234ABC567", then the formula needs to return only 1234567.
Have fun