Sorting question

E

Ed

I need to sort a worksheet by a column with values like

LX5-C1001
LX5-C1002
LX5-C0003
LX5-C0004
LX5-C2005
LX5-C1006

etc. I need to ignore everything except the last three digits. How
do I do this?

Ed
 
B

Bernard Liengme

You will need a helper column. If the real data is in A1, use =RIGHT(A1,3)
in the helper column and copy down the column.
Sort the block of data.
best wishes
 
Top