How do I change all cells to Proper text in Excel

[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.

[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"

--
Regards,
Dave


"Bruce" wrote:

> 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.