First letter of each word capitalized is Proper case, not sentence.

See help on PROPER, LOWER and UPPER case functions.


Gord Dibben MS Excel MVP

On Tue, 29 May 2007 06:49:00 -0700, oldLearner57
wrote:

hi community

can assist me to solve this ...

example:

A B C
1 living to Eat

2 Eat to LIVE

base on the above A1, I want to change the text to Sentence Case (Capitalise
the 1st lettering)

and in A2, I want to change the text to lower case

any help much appreciated

thanks community for the assistance :)