formula to convert a worksheet from upper case to proper

N

Nancy Cantave

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!!!!!!
 
B

Bob Phillips

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