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?
|