Mark,

You can insert an additional column and construct
a formula to extract the numbers only from each cell.
Then sort on that column.
This is done for you in my brand new "Special Sort" Excel add-in.
I am calling it the beta release. It provides seven different
sort options not readily available in Excel.

Free upon direct request to the adventurous, no instructions are
written yet. - remove XXX from my email address.

Jim Cone
San Francisco, USA
XX



"mark1caroline"

wrote in message
news:mark1caroline.1s2x6j_1121209516.3919@excelfor um-nospam.com...
Hi all,
I have been using Excel for a few years now, but I have only really
scratched its surface.
I have been using Excel to great effect to hold all my stock records,
item part number, prices, manufacturer, description and so on. I
recently been trying to add stock location data, this has worked well
but for one problem, I am approaching a stock count and have tried to
sort the data by bin location. I was expecting the data to be arranged
in an order of location but Excel is jumbling the locations up which
make a stock count difficult.
My location data is AlphaNumeric but this could be changed for a better
string of data if neccesary, but it needs to give clear location data,
which is logical to stores staff.
The locations I have set up consists of a Letter of Rack, Letter of
shelf on the rack, and number of location on the shelf. This would
result in a location of say, AA1, which would be rack A, shelf A, and
location 1. This works fine until AA10 is reached, it puts location 10
in the wrong postion on the spread sheet. I have tried breaking the
string up with dots and slashes. I have tried formatting the cells to
text, numbers and others.
Please help my stock check is looming, and with over 4000 parts to
check with some 500 located parts this will be a long job.
I hope I have described my situation so it can be understood, hopefully
an Excel guru out there may have an answer I am sure there is an easy
way around this problem.
Thanks in advance for any help.
Regards
Mark
--
mark1caroline