Issues using TextSplit

Occasional Contributor

Hi Excel Community,


I'm having issues with the new TextSplit function; mostly that I can't find it. When I start typing "text", I get the old functions (I.e. "Textjoin") but not the new ones. I'm using Office 365 on a Mac and it's version is 16.61, which, in my mind, should have this new functionality. Is there an extension or plugin I need to activate before being able to use them?


In advance, Thank you.

3 Replies
Did you opt in to Insider and select the Beta channel?
best response confirmed by ElRafaVaz33 (Occasional Contributor)


I'm not sure about MAC versions, but TEXTSPLIT() is available so far only for Office Insiders, Beta channel.

Thanks guys, yeah this would explain what's going on