Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sort a column by last character
I am trying to sort a row based on the last character in a string of
characters or if reading right to left, I would be sorting by the first character. Can someone tell me how to do this. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sort a column by last character
You can add another column with a formula like:
=right(a2,1) to get the rightmost character in A2 Then drag this formula down as far as you need. And finally sort the entire range using this "helper" column as the primary key. DPK_02 wrote: I am trying to sort a row based on the last character in a string of characters or if reading right to left, I would be sorting by the first character. Can someone tell me how to do this. Thanks. -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sort a column by last character
For unusual sorting criteria, I use Jim Cone's nifty commercial Add-in called
SpecialSort. It's available at http://www.realezsites.com/bus/primi...e/products.php Vaya con Dios, Chuck, CABGx3 "DPK_02" wrote: I am trying to sort a row based on the last character in a string of characters or if reading right to left, I would be sorting by the first character. Can someone tell me how to do this. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I SORT DATA USING A SPECIFIC CHARACTER IN A CELL | Excel Discussion (Misc queries) | |||
sort on character position | Excel Worksheet Functions | |||
Sort text list by character length - how? | Excel Worksheet Functions | |||
Sort Excel Column on Fifth Character | Excel Worksheet Functions | |||
Find a character to sort on in an Excel cell if not the 1st charac | Excel Worksheet Functions |