Besides what's already been said:

Lack of text-to-column parsing. 

That is, if I have a raw string like

    Blah|2|4|5|www.google.com
    Foo|2|1|1.2|www.twitter.com

It's trivial to have Excel quickly do a text-to-columns on that, using | as a delimiter.  Making data formatting as simple as possible is crucial to people who need to create or interact with data tables on a regular basis.

(You can get much more creative with its use; I regularly format complex, messy data sets with just a few text-to-column interations.)