Hi
Can someone help me to format a cell with proper function. This is to be used in a cell to enter names and it has to covert the text automatically into "proper" function.
Eg. if I enter in A1, "james lee" it should automatically change to James Lee.
Thanks