I have an excel spreadsheet with several hundred VINs and want to truncate to
show only the LAST 6 digits. What formula do I use that will look at the cell
from the right, count 6 digits and delete the remaining digits?
e.g.
1FDWE35LX9DA19804
want to show: A19804