Number sort in Excel

  • Thread starter Thread starter AnitaG
  • Start date Start date
A

AnitaG

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.
 
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) ...
 
Thank you!!! I would like to be able to understand the reasoning behind the
formula but if I never get that I'm still a happy woman.
 
Thank you - I will treasure this formula always!

Sheeloo said:
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) ...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Need help in making asset history in my current database. 1
Creating hierarchy in excel 3
Expand list by a certain number 6
Excel Sorting help 22
How can I replace text with a specific number? 3
Auto sorting to match 1
Conditional Formatting Tricky question 5
Count Occurances of a txt string 1

Back
Top