Page 1 of 3 123 LastLast
Results 1 to 10 of 24

Make the First letter Capital

This is a discussion on Make the First letter Capital within the Excel Questions forums, part of the Question Forums category; This is probably a simple question, but I have searched the archives and cannot find the answer... How can I ...

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    38

    Default

    This is probably a simple question, but I have searched the archives and cannot find the answer... How can I make the first letter of every work a capital letter?

    Thanks for any help!

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690

    Default

    I believe you want to use the PROPER function.

    If A1 contains "This is a test" then PROPER(A1) will return "This Is A Test"

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    65,922

    Default

    In addition, you could use ASAP-utilities, a free download from:

    http://asap-utilities.com


    [ This Message was edited by: Aladin Akyurek on 2002-05-20 13:03 ]

  4. #4
    New Member
    Join Date
    May 2002
    Posts
    38

    Default

    Thanks!

  5. #5
    New Member
    Join Date
    May 2002
    Posts
    38

    Default

    Can I apply proper to an entire worksheet? Or do I have to put it in each cell?

  6. #6
    New Member
    Join Date
    Apr 2002
    Posts
    8

    Default

    On 2002-05-20 13:08, Yadlik wrote:
    Can I apply proper to an entire worksheet? Or do I have to put it in each cell?
    You could try putting this in the worksheet's code module :-

    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim cell As Range
    For Each cell In Target
    If cell.HasFormula = False Then
    cell.Value = StrConv(cell.Value, vbProperCase)
    End If
    Next cell
    End Sub


    [ This Message was edited by: ldry on 2002-05-20 17:21 ]

  7. #7
    New Member
    Join Date
    Mar 2008
    Posts
    15

    Default Re: Make the First letter Capital

    Quote Originally Posted by lenze View Post
    I believe you want to use the PROPER function.

    If A1 contains "This is a test" then PROPER(A1) will return "This Is A Test"
    Hi,

    Have been using your answer and works great but when there is an apostrophe involved it capatalise's the result, example - that's the way i'm going but can't go - That'S The Way I'M Going But Can'T Go...

    How do you fix that...

    Jay

  8. #8
    Board Regular btadams's Avatar
    Join Date
    Jan 2003
    Location
    Richmond, Va
    Posts
    1,875

    Default Re: Make the First letter Capital

    Try something like this:

    =SUBSTITUTE(PROPER(SUBSTITUTE(A1,"'","Q")),"q","'")
    “The early bird gets the worm, but the second mouse gets the cheese.”

    Put Yourself on the Excel Map:
    http://www.mapservices.org/myguestmap/map/MrExcel

    Instructions for Map:
    http://www.mrexcel.com/map.html

  9. #9
    New Member
    Join Date
    Mar 2008
    Posts
    15

    Default Re: Make the First letter Capital

    Quote Originally Posted by btadams View Post
    Try something like this:

    =SUBSTITUTE(PROPER(SUBSTITUTE(A1,"'","Q")),"q","'")
    Cheers,

    That works a treat ...

    Jay

  10. #10
    New Member
    Join Date
    Jun 2011
    Location
    Dublin, Ireland
    Posts
    6

    Default Re: Make the First letter Capital

    Hello,

    First time poster here.

    I am looking to also get a capital for the first word and need to know a command.

    I get XLS data and the words are in all capital. I use the =lower(**) command to get them all in lowercase. but what I want is to also have the first letter in the word to be in capital. What else do i need to achieve this.

    Thanks in advance.

    Andrew

Page 1 of 3 123 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com