lower to upper case letter

Hello everyone,

first off, thanks for the opportunity to be a part of the forum.

Here's my story.

In Excel-file, I have a column with terms all written with low case letters. I'd like to have them all beginning with an upper case letter.
Since there are terms consisting of 1, 2 or more words, the function =large2 doesn't solve the task, because only the first word should begin with a capital letter!

I'd appreciate your suggestions.

Nick's picture

not entirely clear what

not entirely clear what you're after, but try this:

put "nick excel" in A1
=UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))
=>
"Nick excel"

Thank you for responding,

Thank you for responding, Nick.

I didn't quite get what I have to do.

Just to clarify what exactly I need, I have a column with 10000 words.

Example:

discharge
radioactive biological waste
transport container

I'd like to be able to mark the whole column and use a formula which would make the following transformation:

Discharge
Radioactive biological waste
Transport container

I appreciate your help!
Have a nice day.

Nick's picture

ok, then that's exactly what

ok, then that's exactly what I have provided above for you

Now it works. I just had to

Now it works. I just had to "localise" it for German. It turned out to be slightly different:

=GROSS(LINKS(A1))&KLEIN(RECHTS(A1;LÄNGE(A1)-1))

Thanks!