Sorting data - number/text problem

Question

I changed formats of all cells in a column to a Text, but it stays sorted as number :( How to sort it as a text, please?

Example:

78
175
205
493
515
582
1171

sorted as numbers, although format is Text

Answer 1

Hi Procházka,

Thanks for getting back to us. 

As you already have input the raw data formatted as Number, we would like to suggest using helper columns. Please insert a column near the current column you would like to sort alphabetically, pick the first cell and input for example =TEXT(A3, "###"), drag down to the bottom of the entire column, then sort A to Z, and select Expand the selection in the below window.

For more detailed information, please check the below article:

How To Sort Alphanumeric Data In Excel?

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.​​

Let us know if you need further assistance.

Thanks,

Tina

Answer 2

yes, I want the data sorted as text, that means according to first character, then second character etc. Not as numbers.

 The raw data is here

https://www.mfcr.cz/assets/cs/media/Ucetnictvi\_Prehled\_2018\_Vycet-konsolidovanych-jednotek-statu-a-dalsich-subjektu-2018\_v03.xlsx

I want to sort organizations listed there by column IČO, but I want the organization with IČO = 78 listed beside others starting with 7, not at first place.

Answer 3

Hi Procházka,

Thanks for the quick response. 

To sort digit number alphabetically, we need to first format the cells Format as Textbefore inputting any digit numbers. So please first format cells as Text, and then input digit number. Below is my test result with green triangle in the upper left corner indicating they are Text for your reference.

If there is any concern, to better assist you, could you please also share with us the raw data which we assume different from the example in the original post and the information about Q2 in my first reply? 

Thanks,

Tina

Answer 4

1. I want to get it sorted as text, i.e.

1171
175
205
493
515
582
78

2.

Answer 5

Hi Procházka，

Thanks for the query. And we are on this to assist you.

To better assist you , we would like to confirm the followings. Could you please kindly help provide them？

1. Share with an example of the desired result of sorting the data (Format as Text) you listed above.
2. Your exact Office version. 

For Office version, you can find it by clicking File > Account > Product Information. Please capture a screenshot of the entire information under Product Information. 

Note: Please mask your email address to protect your privacy.

Thanks,

Tina