+ Reply to Thread
Results 1 to 8 of 8

Make only first letter at first words to be uppercase, other words is lowercase

  1. #1
    Registered User
    Join Date
    06-18-2009
    Location
    home
    MS-Off Ver
    Excel 2003
    Posts
    11

    Make only first letter at first words to be uppercase, other words is lowercase

    This formula should be very often to use, but i cant found it anywhere, so i ask this here




    For example in a1 is :
    mike is playing basketball, he is very great player

    i want to make it in b1 to be uppercase only in first letter so :
    Mike is playing basketball, he is very great player






    i know about proper formula =proper(a1) , but proper formula is make uppercase to all first letter in all words, we just need first letter in first words to be uppercase (and to every first words after dot if it can)
    i like this forum, a lot unique stuff here

  2. #2
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,360

    Re: Make only first letter at first words to be uppercase, other words is lowercase

    basketmen,

    If this is in cell A1:
    mike is playing basketball, he is very great player

    In B1 put the following formula:
    =UPPER(LEFT(A1,1))&RIGHT(A1,LEN(A1)-1)
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

  3. #3
    Forum Moderator DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Suffolk, UK
    MS-Off Ver
    2002, 2007 & 2010
    Posts
    21,520

    Re: Make only first letter at first words to be uppercase, other words is lowercase

    Another alternative:

    =REPLACE(A1,1,1,UPPER(LEFT(A1)))

  4. #4
    Registered User
    Join Date
    11-19-2009
    Location
    Kampala, UGANDA
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Make only first letter at first words to be uppercase, other words is lowercase

    This is interesting, thnx basketmen for asking. How about if you want the results to appear in A1? Is it possible,

    Thank you in advance,

    Samia

  5. #5
    Forum Moderator DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Suffolk, UK
    MS-Off Ver
    2002, 2007 & 2010
    Posts
    21,520

    Re: Make only first letter at first words to be uppercase, other words is lowercase

    samia67, Welcome to the Board, however:


    Your post does not comply with Rule 2 of our Forum RULES.
    Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

  6. #6
    Registered User
    Join Date
    04-12-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    5

    Red face Re: Make only first letter at first words to be uppercase, other words is lowercase

    Hi,

    Sorry to resurrect this thread, but I have searched everywhere and can't find the answer to my noob question:

    Where do I paste the code =PROPER(A1) in order to capitalize the first letter of all words in a worksheet? And it looks to me like the 'A1' means that I'll only be applying this to cell A1; is there a way I can apply this function to an entire column?

    Thanks in advance.

  7. #7
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,143

    Re: Make only first letter at first words to be uppercase, other words is lowercase

    Peter,,

    Welcome to the Forum, unfortunately:

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  8. #8
    Registered User
    Join Date
    11-29-2012
    Location
    kalyan
    MS-Off Ver
    Excel 2003
    Posts
    0

    Re: Make only first letter at first words to be uppercase, other words is lowercase

    =upper(left(a1,1))&right(a1,len(a1)-1)

  9. #9
    Registered User
    Join Date
    06-04-2014
    Posts
    1

    Red face Make only first letter at first words to be uppercase, other words is lowercase

    For example in a1 is :
    mike is playing basketball, he is very great player

    i want to make it in b1 to be uppercase only in first letter so :
    Mike is playing basketball, he is very great player

    =UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))

    Simply use this code..Cool..
    Last edited by arunmurali; 06-05-2014 at 02:57 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1