I love Excel and think that it is the most useful and feature rich product Microsoft has ever created.
I also think that on average only about 10% of functionality is ever used. That got me thinking. If the product is so useful, what is the most useless function in Excel?
I think I have found one. Have you ever heard about CONCATENATE?
As the name suggests, it joins multiple items. The thing is, you can do the same with the ampersand operator (&).
This begs a question, what is function good for? The answer is simple: absolutely nothing.
Not only does it make you type 10 characters more in order to do exactly the same thing, but because it is a function, it cannot process more than 255 parameters.
This is why I would nominate CONCATENATE for the most useless Excel formula award.
If you can think of any specific scenario where it beats “&” operator, please let me know.