Thread: Sorting data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Sorting data

Hi

Assuming your data is in column A, create a helper column with the
formula
=RIGHT(A1,3)
Copy down as far as required.
Mark all of the data including the new helper column, DataSortchoose
helper column letterAscending

--
Regards

Roger Govier


"Maback" wrote in message
...
I have over 1000 10 digit number productcodes listed in one column, and
I
would need to sort them by the by the last three digits. Any
suggestions?