Thank you - I will treasure this formula always!

"Sheeloo" wrote:

One solution is to have a helper column with the formula
=MID(A1,7,LEN(A1)-2)
Entered in B1 and copied down (assuming your values are in Col A)
and sorting on that column after converting the formula to values (Copy Col
B, Paste Speical-Value) ...


"AnitaG" wrote:

What I have is a list of assets named like this -
Public1, Public2, . . . Public10, Public11, etc. and when I need to do
inventory it is hard to go off of the spreadsheet because of the order in
which these things get sorted. It comes out Public1, Public10, Public11, . .
.Public19, Public2, Public20, etc. Is there a way that I can get it to go in
1,2,3 order since it would make it so much easier to go down the list instead
of having to hunt for the asset I need at the time? I'm sure it is an easy
solution but it escapes me. Thanks for any help.