View original (French)

PROBLEMS WITH ALPHABETICAL SORTING IN EXCEL

Solved
3mile Posted messages 4 Status Member -  
3mile Posted messages 4 Status Member -
Hello,

I am currently in the process of setting up a rather long database, which is why I need to sort my columns alphabetically.
I know how to do it, but I'm facing a small issue that is starting to seriously frustrate me.

Here's a small example in the photo


My problem comes from column B where there are like two blocks sorted alphabetically, which is very cumbersome given that there are more than 200 rows..

If you know the answer, you would be very helpful to me.

Thanks in advance!

P.S. I'm on Excel 16

4 answers

Answer 1 / 4
3mile Posted messages 4 Status Member 5
 
Thank you very much for trying to resolve my issue, but I just noticed that some lines in my column had a space before the word and others did not, so my problem is solved.

Yeah !!!!!
5