MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Upper Case to Lower Case


Posted by Zac on February 12, 2002 1:22 PM

I have Column B already in Upper Case and I want to change it to "proper" case. any ideas? is there a formula or function that when entered in B1 will change the data or should I use Cond Formatting "formulas"?


Posted by Mark W. on February 12, 2002 1:26 PM

Look down 4 rows at...

Posted by Zac on February 12, 2002 1:37 PM

Re: Look down 4 rows at...


* * *

Saw that earlier, but it doesn't solve my
problem. At least I don't understand what you
are suggesting.

If I goto B1 and enter =Proper(B1) I get a result
of "0". I don't want to have to retype the Upper
Case names

Please explain one more time.

Thanks,

Posted by Mark W. on February 12, 2002 1:39 PM

The argument to the PROPER() function...

...should be the cell reference that contains
the text -- not the cell that contains the
PROPER() function. Enter =PROPER(B1) into
cell C1 and copy down as far as needed!


Posted by Zac on February 12, 2002 1:46 PM

Re: The argument to the PROPER() function...

Hi Jim,

Unfortunately, I'm not too great with VB code - where should I put this text? How does this 'private sub workbook_before print' know that my workbook is shared and protected?


I'm trying to alleviate any users from changing anything in the workbook and I need to have the ability to have multiple users access the workbook at the same time.

Thanks! PrintWorksheet Macro Macro recorded 2/12/2002 by Anita Grimes : '

Posted by Mark W. on February 12, 2002 1:49 PM

Zac, your reply below was clobbered by someone!! Repost if you have additional questions. [nt]


Posted by Augustine on February 13, 2002 3:25 PM

Finally! One I can answer. Actually, I cheated but what the heck. Just shell out the bucks for the Power Utility Pak. It does it lickity split and tons of other cool stuff. Worth the money...

-augustine