Help! Sorting problem

  • Thread starter Thread starter Alistair Mitchell
  • Start date Start date
A

Alistair Mitchell

I need to sort a list of alphanumeric values in excel using the numeric part
of the value only. All the values have the format AB123456C but I need the
whole value to show after the sort, not just the numeric part.

Can this be done?

Alistair
 
Assuming your data is in an unbroken list: Add a new column. Insert the
formula =MID(A1,3,6) and copy down to the length of your data. This should
give you just the numerical part of your value. Now you can sort on it.

Whether you chose to display this column after the sort is up to you.
 
Thanks

Alistair


George Nicholson said:
Assuming your data is in an unbroken list: Add a new column. Insert the
formula =MID(A1,3,6) and copy down to the length of your data. This should
give you just the numerical part of your value. Now you can sort on it.

Whether you chose to display this column after the sort is up to you.
Click to expand...
 
Back
Top