Textjoin function not showing on 365 Subscription

Saqib Husain, Syed
Saqib Husain, Syed used Ask the Experts™
on
Hi, I have Office 365 subscription and Windows OS. On one computer I have the TEXTJOIN function whereas it is not available on the other. I remember having to enable it on my first computer (probably because it was in beta testing?). Now I understand that this is a permanent feature of Office 365 Home subscription.

Can someone tell me why it is not working on the other computer.

Also the first computer has option of autosave near the top left but not available on the second computer.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Group Finance Manager
Commented:
You are correct, it should be available on Office 365, have you tried doing a repair on Office just incase an update was interrupted?
Can you check if the other computer in question has the latest version of Office please?
Refer the Support link for the details please and let us know if this did not help
https://support.office.com/en-us/article/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c
https://www.excelforum.com/excel-formulas-and-functions/1272684-textjoin-missing-from-ms-office-home-and-student-2016-a.html
byundtMechanical Engineer
Most Valuable Expert 2013
Top Expert 2013
Commented:
Excel 2016 perpetual doesn't get the TEXTJOIN function--you need either Excel 2016/Office 365 or Excel 2019 perpetual. It may be that you have a perpetual (non-subscription) version of Office 2016 installed on the computer that doesn't have TEXTJOIN.

If you have a multi-computer license for Office 365 but Office 2016 perpetual is installed on your computer, you will need to uninstall the perpetual version before installing Office 365. You won't lose your emails, profile settings or application settings when you uninstall--and the new Office 365 install will immediately start using those settings.

You may also want to consider becoming an Office Insider. I'm on the Fast Channel, which means I get great new features like XLOOKUP, dynamic arrays, UNIQUE and FILTER long before other people.

I show screenshots of the what I see in File...Account for a subscription Excel 2016 and perpetual Excel 2013.
Excel 2016/Office 365 subscriptionExcel 2013 perpetual
byundtMechanical Engineer
Most Valuable Expert 2013
Top Expert 2013

Commented:
I guess it is also possible that updates have been blocked on a valid Office 365 subscription. For Office 365, you'll see your version number to the right of About Excel in the File...Account menu item, as shown in the top screenshot above.

Office 365 Home is supposed to get monthly updates. So I checked to see when the TEXTJOIN and AutoSave features were added. You can decode the version number as year and month in yymm format. So Version 1601 is January 2016, and version 1707 is July 2017.

Version 1601 of the Monthly channel brought the TEXTJOIN and CONCAT functions. https://docs.microsoft.com/en-us/officeupdates/monthly-channel-2016 

Version 1707 of the Monthly channel brought the AutoSave feature. https://docs.microsoft.com/en-us/officeupdates/monthly-channel-2017
It turned out that the installation was not the subscription version.

Thanks to all.
Roy CoxGroup Finance Manager

Commented:
Pleased we could help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial