Thread
:
Sorting a column from the last letter or 2 letters of a part numbe
View Single Post
#
2
Posted to microsoft.public.excel.misc
Jon Peltier
external usenet poster
Posts: 6,582
Sorting a column from the last letter or 2 letters of a part numbe
Use a helper column that uses a formula like =RIGHT(B2,2) to contain the
last two characters, and sort on this column.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"Brian Denny" <Brian
wrote in message
...
Anyone have any ideas on how to sort a column from the last letter or two
letters of a part number rather than the first. Sounds crazy, but it
would
save me hours of work monthly if I could figure this one out.
Thank you.
Reply With Quote
Jon Peltier
View Public Profile
Find all posts by Jon Peltier