Formating a column of numbers

[Greg Scarff]

I have a column of 17 digits (it is a vin number for vehicles)

I need to be able to peel off all numbers (and letters) in this column
except for the last eight digits. Once that is done I can then do the sort
that I need. What's the easiest way to do this?

Thanks!



Greg Scarff
Scarff Auto Center Buick Pontiac GMC
1212 South Main St. Kalispell, MT 59901
(406) 755-7777 (e-mail address removed)

 

[excelmunkey]

Hi Greg,

If your VIN is in cell A1 then in B1 have the formula =RIGHT(A1,8) and
copy this down.

Note that before sorting this new list you will have to copy the 8
character values and paste special (in the edit menu) as values.

Cheers,
JF.

 

[JulieD]

Hi Greg

in an adjacent column type
=right(a1, 8)
where A1 is the first "number" in your list
then fill down (move cursor over bottom right hand corner of the cell, when
you see a + double click)

this will give you the last 8 digits of each cell. You can then copy the
column and choose edit / paste special - values over your original column
if you wish, or use this new column to sort the data by (note, when sorting
using this column, do not select the column, rather select a cell and use
data / sort from the menu to sort by).