I need some characters in the formula.
For example:
In Cell A20, the formula is ‘=Sheet12.M937’.
I need the last 2 characters, ‘37’.
I need some characters in the formula.
For example:
In Cell A20, the formula is ‘=Sheet12.M937’.
I need the last 2 characters, ‘37’.
=RIGHT(FORMULA(A20);2)
ATTENTION: If you would like to give more details to your question, use edit in question or add a comment below. Thank you.
If the answer met your need, please click on the ball to the left of the answer, to finish the question.