Yes, you're right, Paul - thanks for pointing this out.

Pete

On Jan 14, 10:56*pm, "PCLIVE" wrote:
I just realized the other formula is missing one too.
=UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))

--

"PCLIVE" wrote in message

...



Peter,

I think your first suggestion is missing a ")". *I'm thinking it should
be:
=UPPER(LEFT(A1,1))&RIGHT(A1,LEN(A1)-1)

Regards,
Paul

--

"Pete_UK" wrote in message
...
Like this:

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

This leaves the rest of the string unchanged and capitalises the first
letter. You may like to add this amendment:

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

which will ensure that the rest of the string is lower case.

Hope this helps.

Pete

On Jan 14, 10:13 pm, Lightjag
wrote:
I am referencing a text string in excel, and would like to return the
text
string with the first letter capitalized. How can I do this?- Hide quoted text -

- Show quoted text -