Sorting on only certain characters in a cell
On Nov 25, 12:31*pm, Lesa wrote:
I am trying to sort on a column that contains items such as the following:
P8692
LT6140
3511
The last 4 numbers are the last 4 of a VIN number and are the only ones I
want to sort on (would like to ignore the first characters and only sort on
the last 4).
Can anyone help?
Assuming your data is in column A
You could insert a hidden column next to your data, and then us a
=Right(A1,4) to get the VIN and sort by it.
|