I am sorting a list of client names. One of the companies' names starts with AAA. For some reason, when I sort the range by alphabet, this name ends up at the end of the list (under names starting with Z). Why is this? Is there any way to fix it?
Note, it is not an option to change the name to something else, as there are many lookups and links to other reports where that exact name is used.
Note, it is not an option to change the name to something else, as there are many lookups and links to other reports where that exact name is used.