I need to sort alphanumeric entries.
The entries I am looking at are:
70
85
162
248
851
70/70M
70M
85#
162M
248/248M
851e
I want them to be sorted in the following order:
70
70/70M
70M
85
85#
162
162M
248
248/248M
851
851e
Any suggestions on how I can go about sorting the values will be very much appreciated!!
That's a custom sort for which you'd need to use VBA. For example, if you pasted those values into A1:A11 you could run a macro like this to sort the list:
WBD
Please Login or Register to view this content.
Office 365 on Windows 11, looking for ✶ rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks