how to create 1st letter of every word capital ?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cooldude7
    Confirmed User
    • Nov 2009
    • 4306

    #1

    how to create 1st letter of every word capital ?

    in word or in excel

    i have about 489 lines with data and i want to create 1st letter of every word capital ..

    how can i do that ?

    help needed.

    thanks for your time.
  • DBS.US
    Geo Cities
    • Aug 2003
    • 11843

    #2
    Have an unused domain? Make a Free Chaturbate White Label site and be making money tonight

    Comment

    • mattz
      Confirmed User
      • Dec 2001
      • 7697

      #3
      a simple search brought up this page with codes...not sure if it will help

      http://php.net/manual/en/function.ucfirst.php

      Comment

      • cooldude7
        Confirmed User
        • Nov 2009
        • 4306

        #4
        Originally posted by mattz
        a simple search brought up this page with codes...not sure if it will help

        http://php.net/manual/en/function.ucfirst.php
        thanks , i am already working on it.,

        Comment

        • L-Pink
          working on my tan
          • Mar 2005
          • 39151

          #5
          Originally posted by cooldude7
          thanks , i am already working on it.,
          Careful, don't get carpal tunnel from the shift key.

          .

          Comment

          • Tempest
            Too lazy to set a custom title
            • May 2004
            • 10217

            #6
            use editplus.. then select all the text and press Ctrl+Shift+U.

            Comment

            • cooldude7
              Confirmed User
              • Nov 2009
              • 4306

              #7
              Originally posted by Tempest
              use editplus.. then select all the text and press Ctrl+Shift+U.
              just downloading., i was doing something with this http://www.php.net/manual/en/function.ucwords.php

              Comment

              • cooldude7
                Confirmed User
                • Nov 2009
                • 4306

                #8
                Originally posted by Tempest
                use editplus.. then select all the text and press Ctrl+Shift+U.
                damn, this is the best motherfucker application., work done.,

                i love you., thanks for saving me from coding.

                Comment

                • cooldude7
                  Confirmed User
                  • Nov 2009
                  • 4306

                  #9
                  just noticed its called capitalize and found something

                  http://office.microsoft.com/en-us/wo...010210665.aspx

                  sucks i am using office xp.

                  Comment

                  • Tempest
                    Too lazy to set a custom title
                    • May 2004
                    • 10217

                    #10
                    Originally posted by cooldude7
                    damn, this is the best motherfucker application., work done.,

                    i love you., thanks for saving me from coding.
                    Yep, editplus rocks.. Been using it for many years.

                    Comment

                    • seeandsee
                      Check SIG!
                      • Mar 2006
                      • 50945

                      #11
                      there is no such option in word? strange
                      BUY MY SIG - 50$/Year

                      Contact here

                      Comment

                      • cooldude7
                        Confirmed User
                        • Nov 2009
                        • 4306

                        #12
                        Originally posted by seeandsee
                        there is no such option in word? strange
                        yes there is "capitalize each word"

                        http://office.microsoft.com/en-us/wo...010210665.aspx

                        Comment

                        • Mr Pheer
                          So Fucking Banned
                          • Dec 2002
                          • 22083

                          #13
                          Use Ultra Edit, highlight the text then hit F5

                          Or just go here, paste the shit in the window and hit the correct button.
                          http://textmechanic.com/Letter-Case-Converter.html

                          Comment

                          • ottopottomouse
                            She is ugly, bad luck.
                            • Jan 2010
                            • 13177

                            #14
                            Capitalising Every Word Makes For The Most Horrible Text To Read.
                            ↑ see post ↑
                            13101

                            Comment

                            • Mr Pheer
                              So Fucking Banned
                              • Dec 2002
                              • 22083

                              #15
                              You're welcome

                              Comment

                              • PromoterX
                                Confirmed User
                                • Sep 2010
                                • 949

                                #16
                                Code:
                                Sub Proper_Case()
                                
                                'This will make the first letter of the text within any selection of 
                                'cells uppercase.
                                
                                For Each x In Selection
                                x.Value = Application.Proper(x.Value)
                                Next
                                
                                End Sub
                                Why re-invent the wheel.... codes out there for the taking people.

                                Comment

                                • cooldude7
                                  Confirmed User
                                  • Nov 2009
                                  • 4306

                                  #17
                                  Originally posted by ottopottomouse
                                  Capitalising Every Word Makes For The Most Horrible Text To Read.
                                  those text lines are just for titles...

                                  Comment

                                  • cooldude7
                                    Confirmed User
                                    • Nov 2009
                                    • 4306

                                    #18
                                    Originally posted by Mr Pheer
                                    Use Ultra Edit, highlight the text then hit F5

                                    Or just go here, paste the shit in the window and hit the correct button.
                                    http://textmechanic.com/Letter-Case-Converter.html
                                    thanks a lot.

                                    Comment

                                    • cooldude7
                                      Confirmed User
                                      • Nov 2009
                                      • 4306

                                      #19
                                      Originally posted by PromoterX
                                      Code:
                                      Sub Proper_Case()
                                      
                                      'This will make the first letter of the text within any selection of 
                                      'cells uppercase.
                                      
                                      For Each x In Selection
                                      x.Value = Application.Proper(x.Value)
                                      Next
                                      
                                      End Sub
                                      Why re-invent the wheel.... codes out there for the taking people.

                                      i am kind of new in coding so, this is a bot ccomplicated for me.,

                                      thanks for your reply.

                                      Comment

                                      • 96ukssob
                                        So Fucking Banananananas
                                        • Mar 2003
                                        • 12991

                                        #20
                                        holy christ, can't believe no one has answered this...

                                        assume cell A1 has the following text "blah blah blah i like cock."
                                        the formula in cell B2 =proper(A1) will = "Blah Blah Blah I Like Cock"
                                        Email: Clicky on Me

                                        Comment

                                        • mikephat
                                          Registered User
                                          • Mar 2008
                                          • 33

                                          #21
                                          in word:

                                          Select text,
                                          Format -> Change Case -> Title Case

                                          Comment

                                          • harvey
                                            Confirmed User
                                            • Jul 2001
                                            • 9266

                                            #22
                                            This post is endorsed by CIA, KGB, MI6, the Mafia, Illuminati, Kim Jong Il, Worldwide Ninjas Association, Klingon Empire and lolcats. Don't mess around with it, just accept it and embrace the truth

                                            Comment

                                            • Doug E
                                              Confirmed User
                                              • Sep 2005
                                              • 511

                                              #23
                                              op wants word or excel but for anybody looking for a css option..

                                              text-transform: capitalize;

                                              Comment

                                              Working...