Why does Excel not sort A-Z? For example: if I create a column and add 262, 262B, 263, 263 Acorn, 264, and 265, and then I sort them, they will come out 262, 263, 264, 265, and 262B, 263 Acorn. Is there a way to sort them so they come out the former?
valid question