Forum Discussion
Solved
Excel Customized Sort List
I have created a custom sort list in Office 365 in Excel and I'm trying to sort in the sequence of the list but it's not working. Does anyone have any suggestions on why it's not working?
SherryHoward You need to clean-up your data in column A, then it will work.I'm certain. Sorting "2P13H01" is not the same as "2P13H01 "
Rajesh_Sinha I tried it but it didn't work. Maybe I'm not doing something right. But I followed your instructions.
It's very unfortunate that you are unable to handle your data, and the method I've shown,,, what else any one can do,,,, especially when I've used your WB and attached with my post as a solution!!!
Let me remind that NO NEED to clean the data in Column A,,, since don't have any WHITE SPACE !!