All Caps into Initial Caps 
Author Message
 All Caps into Initial Caps

From Excel Help

PROPER
See Also

Capitalizes the first letter in a text string and any other letters in text
that follow any character other than a letter. Converts all other letters to
lowercase letters.

Syntax

PROPER(text)

Text   is text enclosed in quotation marks, a formula that returns text, or
a reference to a cell containing the text you want to partially capitalize.

Examples

PROPER("this is a TITLE") equals "This Is A Title"

PROPER("2-cent's worth") equals "2-Cent'S Worth"

PROPER("76BudGet") equals "76Budget"

HTH


Quote:
> is there a fast way in Excel to turn columns in all caps
> into initial caps?  Thanks



Fri, 13 Aug 2004 23:48:50 GMT  
 All Caps into Initial Caps
See

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

--

Regards,

Peo Sjoblom

ROT13 email

Quote:

> is there a fast way in Excel to turn columns in all caps
> into initial caps?  Thanks



Fri, 13 Aug 2004 23:55:17 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. ?ALL CAPS to Initial Caps?

2. How to convert all caps to initial caps

3. Function to turn all caps into initial caps

4. Changing all caps to initial caps

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

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

7. convert ALL CAPS to All Caps

8. change small caps to big caps

9. CAPS to Caps

10. Changing all caps in names to 1st letter in caps only


 
Powered by phpBB® Forum Software © phpBB Group