ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sorting Columns (https://www.excelbanter.com/excel-discussion-misc-queries/213484-sorting-columns.html)

Curious Educator

Sorting Columns
 
Can I sort by the second letter in a column? The first letter is the same but
the second letters are different and I need the sort to the second level..

Thansk,

David Biddulph[_2_]

Sorting Columns
 
Produce a helper column with =MID(A1,2,1), and sort by that column.
Of course, if the first letter is the same, a normal sort would sort by the
second letter.
--
David Biddulph

"Curious Educator" <Curious wrote in
message ...
Can I sort by the second letter in a column? The first letter is the same
but
the second letters are different and I need the sort to the second level..

Thansk,





All times are GMT +1. The time now is 02:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com