I have a cell containing: GB10_4.12.2014

I need to split into a new cell the number(s) to the right of the second character and to the left of the "_", which in this case is 10.

Another cell contains: MC1_4.12.2014

In this case the function would return the number 1.


Assuming your value is in A1 cell try this way:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.