Forum Discussion
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...
PROPER function should work pretty fine.
Let say you have DONE in cell A1. In cell B1, enter =Proper (A1) and hit enter. It should deliver Done in cell B1
I suggest you close your Excel workbook and reopen and run the formula.
Cheers