=PROPER(A1)

HTH
--
AP

"Jeff" a écrit dans le message de news:
...
Hi, I am trying to auto format excel entry to default capital letter for
1st
letter of each word. For example: When user insert '10, international
building, sunny road', the entry will updated to '10, International
Building,
Sunny Road'.

Please show me the method.

Your help is very much appreciated.

Jeff.