Ask Your Question
0

Calc: How to extract characters from formula

asked 2019-08-31 04:22:39 +0100

lonk gravatar image

I need some characters in the formula.

For example:

In Cell A20, the formula is '=Sheet12.M937'.

I need the last 2 characters, '37'.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-08-31 04:35:02 +0100

=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 Descrição da imagem to the left of the answer, to finish the question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-08-31 04:22:39 +0100

Seen: 20 times

Last updated: Aug 31