For the 14 years during which I used excel daily, the first 4 items you listed didn&#x27;t affect me and the last two never mattered.  I used text-to-columns to very nicely parse pipe-delimited files.  The leading zeros issue I bumped into several times and was a minor irritation to fix.