This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello,
Here's my sorting issue. Using MS Word 2010, we often work with simple tables with several columns. One column we have contains patient room numbers. We need to sort those room numbers, but instead of getting this order: A1, A2, A10, etc., we get this order: A1, A10, A2, etc. I understand how to sort but choosing the numbers sorting does not work since there is a letter before each number. How can I sort the numbers properly when there is a letter just before each number? Thanks!
Ron
A family of Microsoft word processing software products for creating web, email, and print documents.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
If you can number the rooms as A01, A02, etc., then the sort will work as expected. You can select the zeros and format them as Hidden, then display Hidden text when you need to sort. You'll need to sort by Text, as Word can't seem to figure out how to sort by Number with the A's in front.
Thank you very much for replying. I'll give this a try. Makes sense. Should have been obvious to me. Hope you have a happy and a great new year!
Ron