Truncating a VIN

L

lputnam

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
 
J

JLatham

Assume that a VIN number is in cell A2
=right(A2,6)
will give you the last 6 characters.
 
C

CLR

DATA > TextToColumns > setting a fixed column break is also another way to
break off the rightmost 6 characters

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing 18 digits or more in a cell 1
need a formula to find "*" in s string and multiply by preceding andfollowing values 5
Hiding number parts by cell formatting 4
Three digit commas separator 3
Numbers to sort as text 5
Vlookup only the last 6 characters 2
Trim all but the last four digits off a list of SSN's. 2
last 6 of the vehicle VIN 2

Top