Data Validation Proper Case

Validation to force proper case (ie first letter Caps only) where a suburb name is entered.
How do I acheive this. eg SEVEN HILLS when entered is converted to Seven Hills.


You could try this formula PROPER(), it would 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.