Forum Discussion
Excel Customized Sort List
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 "
SherryHoward The sequence in column A exists of text strings, each 20 characters long. 7 visible characters plus 13 trailing spaces. Your custom sort list consists of elements containing only the first 7 characters. Use =TRIM(A1) and copy down to get red of the trailing spaces. Then copy/paste values back into column A and apply the custom sort. Then it shall work.
Thank you for responding, I am trying to have the column sort the numbers in the order provided in the custom sort; should that work or am I doing something wrong? I did try what you provided but that didn't work. I sent the file in my first message.
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 "
Okay, having it cleaned up, will try again. Thank you so much. I will let you know the outcome.
Sincerely,
Sherry