TEXTSPLIT, TEXTBEFORE and TEXTAFTER Functions

[ranjith2523]

Hi Friends,

I am using Office 365 and the TEXTSPLIT, TEXTBEFORE and TEXTAFTER Functions not available in my excel.

if i type =TEXT in my excel i could only TEXT and TEXTJOIN function. So, please let me know how do i make in work in my Excel.

Thanks for all your help in advance.

Regards,
Ranjith

 

[Fluff]

Those functions are currently only available on the Insiders Beta channel.
You can sign-up for it by going to File, Account & click on Office Insider.

 

[ranjith2523]

Those functions are currently only available on the Insiders Beta channel.
You can sign-up for it by going to File, Account & click on Office Insider.

Thanks for your prompt reply...

I don't see the Office insider BOX in File, Account

Hence I followed the below points and successfully completed till the 5th point but still TEXTSPLIT function is not available .. any suggestion, please..

1. From any Office app on Windows, click File > Account > Office Insider > Join Office Insider
2. In the Join Office Insider dialog box, click the box next to “Sign me up for early access to new releases of Office”
3. Select the Insider channel you want
4. Click the box to agree to the terms and conditions
5. Click OK.

 

[Fluff]

Did you choose the Beta Channel?

 

[ranjith2523]

Did you choose the Beta Channel?

Yes.. Please look into the below screen shot .. even i restarted the excel.. Should i reboot my laptop ?

 

[Fluff]

I would just wait a few days, I don't know how long it takes to catch up.

 

[ranjith2523]

I would just wait a few days, I don't know how long it takes to catch up.

Thank you so much for your reply.. Based on your reply I understand that I need to wait for a few days correct ... Please share if you get to know anything about this...

FYI., I don't see any progress even after I click the OK button

 

[Fluff]

I am not on either of the Insider channels, so have no idea how long it might take.