If I have in a cell, let's cell A1:
19095551212
and, in B1, I only want to see the last 7 digits of the number (5551212), how would I do that?
I want to apply this to a huge list of numbers where I only want to see the last 7 digits of every number.
Thanks.
19095551212
and, in B1, I only want to see the last 7 digits of the number (5551212), how would I do that?
I want to apply this to a huge list of numbers where I only want to see the last 7 digits of every number.
Thanks.