I use FileMaker at the middle school level to keep data on students. When I sort my students alphabetically it puts all students who have a punctuation mark in their name or a space in their last name before those without. For example John O'Mary will be before John Odle and D'Angela Smith will be before Angela Smith. It also does this with students whose last name is more than 1 word. So Jane Ramirez Mar is before Jane Ramirez.
Is there any way to change the settings to where it will ignore spaces and punctuation marks in the field when sorting alphabetically?