Sorting Text in Excel 12:18 24 Feb 03

Is it possible to segregate cell with text ending in specific characters.

I have a list of product codes. Some end with the notation "-S". Is it possible to sort only the products ending with "-S"

  Cantillion 13:32 24 Feb 03

There's probably an easier way, but this will work :-)

First off, type =RIGHT(XY,1) in a cell in the same row as your code, where XY is the cell reference of your PRODUCT CODE (the one ending in s). This will return "s" for codes ending in s, (or the last didget if not). Now drag the forumla down so that it is in every row of your table...

Now apply an autofilter (highlight the top row, Data > Filter > Autofilter), then in the column where you have S or a number, click s in the drop down box.


This thread is now locked and can not be replied to.

Nintendo Switch (Nintendo NX) release date, price, specs and preview trailer: Codename NX console…

1995-2015: How technology has changed the world in 20 years

8 things designers (and brands) need to know about the modern woman

How to speed up a slow Mac: 19 great tips to make an iMac, MacBook or Mac mini run faster | Speed…