MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Proper Case


Posted by Claudia Jaeger on February 12, 2002 12:49 PM

Would you please let me know how to change all capital words to proper case? Help!!!

Thanks a lot!


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

=PROPER("HELP") or =PROPER(A1) where A1 contains "HELP" [nt]