Gord,

Paul Clive has pointed out that I missed a bracket off - should be:

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

Pete

On Jan 15, 12:22*am, Gord Dibben <gorddibbATshawDOTca wrote:
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.- Hide quoted text -

- Show quoted text -