Try the =proper() function...

If the text that you want to represent a change to the format of the letter
characters is found in cell A2 the correct syntax would be

Proper case =proper(A2),
Upper case =upper(A2),
Lower case =lower(A2)
--
Thanks for your help -
Joe Mac


"philippos" wrote:

I want to be able to change capital letters into title case. A colleague and
I have
tried to follow the instructions given by the online Help but cannot figure
out how to make this work. The instructions are not very well explained