What am I doing wrong?

Both of these leave me with all upper case.

=UPPER(LEFT(A1,1)&RIGHT(A1,LEN(A1)-1))

=UPPER(LEFT(A1,1)&LOWER(RIGHT(A1,LEN(A1)-1)))

A1 contains this is some text


Gord Dibben MS Excel MVP

On Mon, 14 Jan 2008 22:39:40 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

PROPER will capitalize the first letter of each word, while Pete's formula
capitalizes just the first word of the string.