Help! Sorting problem

[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

 

[George Nicholson]

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.

 

[Alistair Mitchell]

Thanks

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.