How can I show text as value on a pivot table on Excel for Mac?

I am aware that windows PC you can use the Cancatenatex function to do that, but how can I do that on a MAC - as this option does not seem to be available. Any advice would be great! Thanks