on excel - how sort letters before numbers
how do you set up a sort to have alpha first, then numeric
|
on excel - how sort letters before numbers
Gerry wrote:
how do you set up a sort to have alpha first, then numeric Let's say you have the items in Column A. First sort all, largest to smallest. This will put the letters first, followed by the numbers but they'll both be in descending order. Then sort on just the letters in the column, smallest to largest. Then sort on just the numbers in the column, smallest to largest. Hope you don't have to do this too often... Bill |
All times are GMT +1. The time now is 01:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com