I have a calculated Site Column which I want to be some text "PRJ" plus a number from another site column (type number - nothing after the '.') (PRJ-ID - value 00001) in the content type. I try and Use ="PRJ" &TEXT([PRJ-ID]) but I get an error "The formula contains a syntax error or is not supported. " I got the Formula from - https://msdn.microsoft.com/en-us/library/office/bb862071(v=office.14).aspx - combine text and numbers from different columns.
I have been through the previously answered questions, but found nothing.
What have I done wrong ?