Re: Capitalize first letter in sentence

Tech-Archive recommends: Fix windows errors by optimizing your registry

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.

.

Relevant Pages

  • Re: How to use the UNIX command: tr
    ... > "Does anyone know how to convert a lower case string to upper case ... > Which ignores the OPs question, even though the poster is obviously ... I'm sorry, that is my response, taken out of context. ...
    (comp.unix.solaris)
  • Re: How to use the UNIX command: tr
    ... > I know very well they are POSIX compliant keywords. ... "Does anyone know how to convert a lower case string to upper case ... Which ignores the OPs question, even though the poster is obviously ...
    (comp.unix.solaris)
  • Re: use of uppercase and lowercase in codes
    ... > case should be upper case is there any rule. ... > in the first word B and R upper case but in <reader? ... > sorry this is a qustion from an absolute beginner in Java programming ... Most method names begin with lower case letters, ...
    (comp.lang.java.help)
  • How to add a string to a big file in csharp !
    ... I want to add a string to the file and the file is sort by letter! ... string str = sr.ReadLine; ... long upper = fs.Length - 1; ... the FileStream is fitable in it? ...
    (microsoft.public.dotnet.languages.csharp)
  • How to add a string to a big file in csharp !
    ... want to add a string to the file and the file is sort by letter! ... Just after "cabbage" and at the front ... string str = sr.ReadLine; ... long upper = fs.Length - 1; ...
    (microsoft.public.dotnet.general)