Return selected characters in an excel cell

Closed
Posts
1
Registration date
Tuesday June 11, 2013
Status
Member
Last seen
June 11, 2013
-
Posts
7099
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
January 20, 2022
-
I have a alphanumerical number like the following:

C297320

I need to return the last 3 digits of this number in a separate cell.

Thus, I need: 320

Please help!
Thanks in advance

1 reply

Posts
7099
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
January 20, 2022
490
Hi,

I supposed C297320 is into Cell A2, try this formula :
=RIGHT(A2;3)

Regards