View Single Post
  #1  
Old September 24th, 2010, 02:41 PM
JustinRey JustinRey is offline
Member
 
First recorded activity by OfficeFrustration: Sep 2010
Posts: 1
Default Ignoring space alphabetic list

Hello everbody,

I have this little problem with a worksheet in excel. I was trying to make an alphabetic order ( from A to Z ). Than I noticed excel doesn't do it like I want it to.

For example, I have a list with all my school students, but when I try to sort them the pupil with last name "De Rore" is displayed before pupil "Deblaere". I figured out this is because of the spacebar, but I don't want this.

Does somebody know if I'm possible to ignore the space so it can be sorted properly?

Thank you very much,
some feedback would be great!

~ Justin

Ps. if necessary I can conclude the list of students.