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
