Return selected characters in an excel cell

Closed
luiyoo Posts 1 Registration date Tuesday June 11, 2013 Status Member Last seen June 11, 2013 - Jun 11, 2013 at 11:10 PM
aquarelle Posts 7119 Registration date Saturday April 7, 2007 Status Moderator Last seen October 18, 2022 - Jun 12, 2013 at 07:25 AM
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

aquarelle Posts 7119 Registration date Saturday April 7, 2007 Status Moderator Last seen October 18, 2022 491
Jun 12, 2013 at 07:25 AM
Hi,

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

Regards
1