How do I change all cells to Proper text in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I locate a circular formula? 2
Circulair error message 2
Circular reference, Indirect, and Sum 3
To remove numbers in a cell with out using the macro 3
change cell event using circular reference - not VBA! 3
if statement, change cell only if true 4
subtotals in excel 2
Recalculating in a circular reference 3

Back
Top