Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple alpha numeric sorting
Hi all,
I have absolutely NO experience with excel, and I am trying to sort lot numbers which are followed by a letter; eg: 1B 5B 19B 45B 190B 247B 560B However I can only sort so it renders my results 1B 19B 190B 247B 45B 5B 560B Every formula I've looked at is much too complex for what I'm trying to do, and as I have no experience with excel, I do not understand how to adapt the formula to my needs. Help would be greatly appreciated, but please in lamen's terms. :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple alpha numeric sorting
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
alpha numeric sorting | Excel Discussion (Misc queries) | |||
Alphanumeric Sorting - numeric alpha numeric | Excel Worksheet Functions | |||
Sorting alpha numeric data | Excel Discussion (Misc queries) | |||
Sorting Alpha Numeric | Excel Discussion (Misc queries) | |||
Alpha-Numeric Sorting | Excel Discussion (Misc queries) |