Text Column not sorting correctly alpabetically

Question

I've created a list with two columns. It contains Country Name (first column) and their 2 character abbreviation (second column).

Example:

Italy - IT

Sweden - SE

United Kingdom - UK

I've setup the list to sort on the column with the name "2 Characters".

Problem I experience, is that the list is not sorted correctly. There is a mix in the sorting. Like SE comes before IT.

What can be the cause to this?

Here is the settings for sorting the list for the view AllItems.

Unfortunately I am not able to add a screenshot at this moment. Will get back when I am at that customer. I choose Asc order. Unfortunately your answer did not help. — Andreas, Commented Dec 9, 2015 at 6:03
I guess the "2 character" column is the calculated column, and I think SP meet little trouble with sorting on calculated column. — dant, Commented Dec 10, 2015 at 9:02

Atish Kumar Dipongkor · Accepted Answer · 2015-12-08 09:46:56Z

2

Modify your view and choose

Show items in ascending order

(A, B, C, or 1, 2, 3)

Now SE should not come before IT, see my screenshot

answered Dec 8, 2015 at 9:46

13.4k5 gold badges32 silver badges64 bronze badges

I've set it up just like in your screenshot. Yet it does not sort correctly.
– Andreas
Commented Dec 10, 2015 at 7:05
Does SE contain any extra spaces ?
– Atish Kumar Dipongkor
Commented Dec 10, 2015 at 7:17
No, there are no extra spaces.
– Andreas
Commented Dec 10, 2015 at 20:05

Add a comment |

MikhailSP · Accepted Answer · 2015-12-08 09:44:45Z

0

Probably, you created/changed the view with sorting, but selected another view? If not, please, attach a screenshot of the view settings.

answered Dec 8, 2015 at 9:44

MikhailSP

1,4492 gold badges13 silver badges26 bronze badges

I've checked that as well, but nothing that indicates that it should be conflicting somewhere.
– Andreas
Commented Dec 10, 2015 at 7:06

Add a comment |

2 Answers 2