Anyone Know Of Anything?
Need a tool that converts ALL CAPS to First Letter Of Each Word Caps
Collapse
X
-
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.Comment
-
I could write a program that does this easily,
Would you want it web based?
Where is the text going?Comment
-
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.Comment

Comment