If you've ever tried to use the CONCATENATE function in
Microsoft Excel to merge the values in a range of cells, you know it doesn't work unless you add each cell to the function, one by one.
You might have noticed the following message in the support article for CONCATENATE:
Important: In Excel 2016, Excel Mobile, and Excel Online, this function has been replaced with the CONCAT function. Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from now on. This is because CONCATENATE may not be available in future versions of Excel.
Meet the alternatives: CONCAT and TEXTJOIN
for CONCAT and TEXTJOIN:
Note: This feature is not available in Excel 2016 unless you have an Office 365 subscription. If you are an Office 365 subscriber, make sure you have the latest version of Office.
While it is admirable that Microsoft is finally fixing some of the idiosyncrasies of its software, I fear the future will bring a level of fragmentation unseen since the office 2003 to 2007 switch.
>And if, like most companies, you already have invested in highly complex Excel spreadsheets
like a foolish man, who built his house on the sand. The rain came down, the floods came, and the winds blew, and beat on that house; and it fell—and great was its fall
Not migrating to openoffice/libreoffice/some math package/pyspread/business object environments like pharo as a mere backup/alternative means most companies simply think the only tool they have is the best for the job. Good luck to them.
It's a matter of employee training and experience. There is a steep learning curve associated with moving off a platform like MS Office which has an existing knowledge base in the corporate world. The man hours lost trying to train and maintain employees on an unfamiliar system, the vast majority of whom are technically unskilled, is far higher than simply paying the troll for MS Office that everyone already knows.
For example, the city of Munich made headlines when they said they were dumping windows and ms office for linux and libreoffice. It took them TEN YEARS to make the transition and after 3 years they ended up dumping it all and went back to windows. Opensource software is great in the backend server world, but on the client side Microsoft still reins, warts and all.
> after 3 years they ended up dumping it all and went back to windows.No, somebody else did. Politicians get elected and subbed.