Need a tool that converts ALL CAPS to First Letter Of Each Word Caps
 

Anyone Know Of Anything?

If you ran a string through a php script:

$str="SOME STRING BLAH BLAH BLAH";
echo ucfirst(strtolower($str));

???

in what exactly? a file name? like PIC.JPG etc..?

if so you can try Princeton File Renamer

ucwords() php function

just paste the all caps shit into a thread on gfy, it will do it for you

You can even paste it into the quick reply, then hit go advanced, and it will transform it for you

This Was All Caps When I Hit Reply

Or paste it into MS Word, hilight the text, Format -> Change Case -> Title Case option.

its in excel, text, line by line.

Thanks, I will try all of those, I think MS Word only shows it in msword and when you copy it to another program it shows the caps again but I will try all these :) Thanks

If you can avoid using MS Word, do so. Nothing can fuck up text like a Microsoft application. I swear by Textpad (you can get a trial). If you can export the excel file as CSV text, you can do the change case thing in Textpad, and then reimport the entries into a new Excel file.

I could write a program that does this easily,

Would you want it web based?
Where is the text going?

Try textmagician, it's free

Good try, but you gotta make sure that there's no punctuation or other characters in the string.

HE SAID HIS NAME WAS "JOHN"
would become
He Said His Name Was "john" because PHP regards " as the beginning of the word.

Take a look at http://us3.php.net/ucwords for some potential fixes.