How do I change all cells to Proper text in Excel

B

Bruce

I have followed previous postings but I am getting Circular reference errors
when I try to perform the fucntion on the cell I am trying to change.
 
D

David Billigmeier

You have to place the formula in a different cell. For example if the text
"PrOper TeXt" was in A1 and you placed the formula =PROPER(A1) into B1, B1
would have the value "Proper Text"
 
Top