I desperatly need help

[Joseph Heusmann]

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 sort. I was searching a description and all of a sudden it refuses to organize properly. Qoutation marked titles are sorted together aqnd that's it. I did not do anything to make this happen. I am so regretting that I trusted Excel for this. 

[#2]

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.