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

[Jsodha]

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 

[#2]

@Jsodha  CONCATENATEX is a function used in DAX measures within Power Pivot. That feature is not available on the Mac