phaolo: Mm.. you have to get rid of that with a TRIM() function in another column or manually with Notepad++ or similar.
lugum: Years ago i had a job where i worked with excel and knew this kind of stuff, but i can't remember how to use the trim function anymore, worse case i have to it manually.
It's easy, trust me. Just:
- create another column
- paste this in the first cell (use your cell reference):
=TRIM(A1) - extend the formula to all the column
- from now on, sort by this new column
end!
: )