Is there a way to change the font case in Excel to all caps or all lower
case? I need to sort a column and have mixed fonts that are interferring with
my sort and I do not want to do this in Word.

If not, is there a way to make Excel ignore font setting?