convert ALL CAPS to All Caps 
Author Message
 convert ALL CAPS to All Caps

Any way to convert all caps names to properly
capitalized.... probably some sort of macro I could do...
huh!


Tue, 25 Oct 2005 23:23:20 GMT  
 convert ALL CAPS to All Caps
Take a look here:

    http://www.mvps.org/dmcritchie/excel/proper.htm


Quote:

> Any way to convert all caps names to properly
> capitalized.... probably some sort of macro I could do...
> huh!



Tue, 25 Oct 2005 23:27:35 GMT  
 convert ALL CAPS to All Caps
=proper(a1)
Quote:
>-----Original Message-----
>Any way to convert all caps names to properly
>capitalized.... probably some sort of macro I could do...
>huh!
>.



Wed, 26 Oct 2005 01:57:36 GMT  
 convert ALL CAPS to All Caps
If ALL CAPS is in cell A1, enter this formula in cell B1:
=Proper(A1)
Changes ALL CAPS to All Caps

On Fri, 9 May 2003 15:23:20 -0700, "jennifer"

Quote:

>Any way to convert all caps names to properly
>capitalized.... probably some sort of macro I could do...
>huh!



Fri, 28 Oct 2005 03:39:57 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. How to convert all caps to initial caps

2. Convert ALL CAPS TEXT to Caps And Lowercase

3. Convert All Caps to non-caps

4. Update query to convert Caps to U/Lower case and U/Lower case to Caps

5. converting text to Initial Caps, vs all caps or lower case

6. I can't convert ALL CAPS to Initial Caps!

7. ?ALL CAPS to Initial Caps?

8. change small caps to big caps

9. CAPS to Caps

10. All Caps into Initial Caps


 
Powered by phpBB® Forum Software © phpBB Group