Forum Discussion
I desperatly need help
I have over 20 hours into a card inventory list and literally out of nowhere Excel refuses to organize the card names alphabetically. It came out of nowhere. With over 250 entries it now will not sor...
Hi Joseph,
Alphabetical sorting in Excel is not exactly "alphabetical", it takes into account quotation and punctuation marks, etc.
If exclude macros the solution could be in helper column which has your texts without quotation marks (generated by Flash Fill or formulas) and when sort both columns based on helper one.