Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort Room Numbers that include Alphabetes
How do I sort room numbers that include alphabetes.
I know that sorting room numbers is pretty easy just highlight the whole spreadsheet (control a). Sort with header row checked and proceed to scroll down to room numbers. The problems when you add alphabetes. The computer sees alphabetes as distinct characters. like 209B 209 A 209C. It is pretty simple to say 209, 210 211. What do I do. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Include ability to sort Excel cells by colour | Excel Worksheet Functions | |||
How do I include filtered out numbers in a SUBTOTAL? | Excel Worksheet Functions | |||
adding cells which include numbers and text | Excel Discussion (Misc queries) | |||
adding cells which include numbers and text | Excel Discussion (Misc queries) | |||
Sum numbers that include #N/A | Excel Worksheet Functions |