How do I sort with spaces? I have spaces between my numbers and dates and names and would like to sort them without using a VBA formula.
You can use the TRIM and CLEAN functions to remove unneeded spaces and store the result in a separate column. After that, use the new column to sort. (See the TechNet article Formula Watch: TRIM and CLEAN your Excel data.)
(Image source: TechNet)
If needed, simply hide the temporary column or delete it completely after sorting