Eliminate numbers in a field

[douglascaixeta]

Hi,

I have over 300 cells with numbers. They all have the same amount of characters and same number structure. Which is 517720143F31000000. I would like to make all field only have the last 6 numbers: 000000 and eliminate the first part. How do I do that?

[Mvaldesi]

Assuming your numbers are in Column A, would this work? (in B1):

=RIGHT(A1,6)

Will give you the last 6 digits in Column B.

[douglascaixeta]

Works perfectly, THank you!

[Mvaldesi]

No worries; glad to help!