Sort Excel Data By Numbers and Text Properly

instead of: game 10 game 2 game 24 game 3 Use ASAP Utilities Tab "Range" icon Select "Advanced Sorting" from the menu Sort By: "Alphanumeric Content" Then By: "Value" to get: game 2 game 3 game 10 game 24

Advertisements

Convert Numbers into Month Names in Excel

To convert cells with month numbers such as 1, 2, 3, 4, etc, use the following formulas: =TEXT(DATE(2000,A1,1),"mmmm") for Full Month Name (January, February, March, April) =TEXT(DATE(2000,A1,1),"mmm") for 3-letter Month Abbreviation (Jan, Feb, Mar, Apr) =TEXT(DATE(2000,A1,1),"mmmmm") for 1st letter of Month (J, F, M, A) Paste the formula in a blank cell to the side … Continue reading Convert Numbers into Month Names in Excel