Using the =PROPER(text) Function

I am trying to convert a column of text that has multiple words in each cell, but all caps. I'm trying to use the formula =PROPER(TEXT) as suggested by the "HELP" function, but it's not working. I cr...