Number sort in Excel
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.
|