formula to convert a worksheet from upper case to proper

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

Guest

I'm having difficulty with the formula to convert my worksheet form upper
case to proper. I'm using =PROPER(A2:A102), but it's creating a circular
reference and i'm not sure how to get around that. Please help!!!!!!
 
That is probably because you formula is in one of those cells, so it is
trying to refer to itself.

Put =PROPER(A2) in cell B2, copy down to B102, Copy B2:B102, goto
Edit>PasteSpecial, and select Values, OK, then delete column A.
 
You are awesome Bob!!! It worked. Thank you for taking the time to respond.
 
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

UPPER CASE 1
convert lower to upper case automatically without using UPPER 6
Validation list with non blanks from different column 3
Excel: how to convert text to upper case upon entry? 13
Making Sheet all Upper Case 3
Changing from upper case to lower case 12
Format Case for only 1
how to make whole work sheet in to upper case 4

Back
Top