Hi,
I just installed MS Office Home and Student 2016 specifically because I needed the TEXTJOIN function. Everything I read says that it was introduced in Office 2016, but when I try to use it, e.g. "=TEXTJOIN(CHAR(10),TRUE,B4,B5,B6)" I get a #NAME error. Also when I click the function button it's not listed. The CONCAT function, which was also supposed to be introduced in Excel 2016, is also not available.
I'm sure the install worked: on the Account screen it says Microsoft Office Home and Student 2016, and when I click on update I'm told that the latest version is installed. The only other potential problem source is that I installed over Office 2007 without uninstalling it first.
How do I get TEXTJOIN?
Thanks,
Mike
Bookmarks