Capitalize Every First Letter Of Word

Microsoft Excel has a formula that could help you to capitalize every first letter on your word easily. I use it every I create a article title so that I don't forget to capitalize it or you can use it for another need. So, if you type "i love you" and then you'll get a result like this: "I Love You".

The name of formula is PROPER(). To using PROPER() formula is very easy, just type PROPER(cell_source). For example if you want to capitalize a sentence in cell A1, just create on empty cell: =PROPER(A1) and you'll get the result soon.
Proper can work on NeoOffice Calc too.