sorting alphabetically without first sorting numerically
Posted by Jonathan Rigby on December 19, 2000 8:48 AM
I'm sure this is really easy, but I'm not that familiar with excel. I have a large spreadsheet of chemical names, some pre-fixed with numbers, some not. I would like to sort alphabetically only, totally ignoring the numerical pre-fixes to get a true alphabetised list. However no matter what I do excel always numerically sorts the ones with numerical pre-fixes first which therefore totally de-alphabetises the list. Can anyone help?