Hai Friends..
In My attached file.. I want to sort the column.. in second letter alphabetically.. first letter we can sort A to Z.. Last Letter Z to A.. How to sort second letter wise alphabetically.
Thanking You..
Hai Friends..
In My attached file.. I want to sort the column.. in second letter alphabetically.. first letter we can sort A to Z.. Last Letter Z to A.. How to sort second letter wise alphabetically.
Thanking You..
Last edited by Shi; 05-18-2016 at 05:48 AM.
You can add two temporary helper columns using these formulae:
D2: =LEFT(B2)
E2: =MID(B2,2,1)
Copy these down, then apply the sort to all 4 columns, using column D and E as the sort fields.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks