| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number sort in Excel
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to sort number properly in excel? | Excel Discussion (Misc queries) | |||
| Can you sort by most to least often recurring number in Excel? | Excel Worksheet Functions | |||
| Sort by number not by letter (C1, A2, B3, D4) | Excel Discussion (Misc queries) | |||
| how can I sort alphanumeric entries by number in excel | Excel Worksheet Functions | |||
| How do you sort words in Excel by the number of letters in a word | New Users to Excel | |||
Hybrid Mode
