Re: Capitalize first letter in sentence

PROPER will capitalize the first letter of each word, while Pete's formula
capitalizes just the first word of the string.
--
David Biddulph

"Gaurav" <gsharma@xxxxxxxxxxxxxxx> wrote in message
news:uvzWE3vVIHA.1208@xxxxxxxxxxxxxxxxxxxxxxx
Hey Pete,

Just curious. Does the formula you mentioned do anything extra than the
PROPER function? Just increasing my knowledge.

Thanks
Gaurav


"Pete_UK" <pashurst@xxxxxxxxxxx> wrote in message
news:61f7dbaa-0fad-4b1d-a3cb-90e59ff03b7e@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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 <Light...@xxxxxxxxxxxxxxxxxxxxxxxxx>
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?




.

Relevant Pages

  • Re: Advanced HTML DOM Issue
    ... I'm sorry, I wasn't explicit enough, I meant to say capitalize the ... the first letter of words and un-cap the rest, ... whole string causes the field to forget where the cursor is ... ...
    (alt.html)
  • Re: Surprise in StrConv using vbProperCase
    ... Your code will capitalize the first letter of a string. ... so the specs for StrConv using vbProperCase match ...
    (microsoft.public.access.modulesdaovba)
  • Re: Need string for capitalization
    ... >> I'm trying to capitalize the first letter of a field but the string I am ... > In a report control Source: ...
    (microsoft.public.access.gettingstarted)
  • Re: [string totitle "ab cd ef"] does not output "Ab Cd Ef" but instead"Ab
    ... Will Duquette wrote: ... > capitalizing a string, sometimes you want to capitalize just the first ... and sometimes you want to capitalize the first letter of every ...
    (comp.lang.tcl)
  • capitalize words
    ... i want the output to be "I Have An Apple"; ... i was able to capitalize the first word but can't figure out how to ... capitalize every word in that string ...
    (microsoft.public.dotnet.languages.csharp)