Using the =PROPER(text) Function

Copper Contributor

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 created a column to the right of the text. I entered the formula in the new column and tried to copy/paste the formula over the original text, but all it does is copy the formula. What am I doing wrong?

2 Replies

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

Try Paste Special - Value (from the paste button on the home tab).