365 feature when opened in 2010

[kweaver]

When a 365 feature such as TEXTJOIN is used in Excel 365 and then the workbook is opened in 2010, will Excel ALWAYS fix the issue?
I've noticed it will automatically create an array formula in 2010 and then use: _xlfn.TEXTJOIN in 2010 for the 365 feature. Can you count on this always?

 

[DRSteele]

Yes, it will do that. Of course, users still using outdated software like Excel2010 will not be able to alter the formulas and will be perplexed when they see it.

 

[kweaver]

Thanks. I realized the latter (re altering formulas), but wanted a confirmation that this will always adjust. Thanks.