Home » Forums » Open Source Learning Center » Question and Answer

lower to upper case letter

Submitted by bluescreendiver on 29 November, 2012 - 15:14

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.

‹ Macro decoding IF Function in VBA ›
»
Nick's picture

not entirely clear what

Submitted by Nick on 29 November, 2012 - 17:30.

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,

Submitted by bluescreendiver on 30 November, 2012 - 09:21.

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

Submitted by Nick on 30 November, 2012 - 09:55.

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

»

Now it works. I just had to

Submitted by bluescreendiver on 30 November, 2012 - 11:08.

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!

»