+ Reply to Thread
Results 1 to 4 of 4

how to change Lower case to capital case in same cell

  1. #1
    Registered User
    Join Date
    11-21-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    1

    Post how to change Lower case to capital case in same cell

    How to change lower case letter to capital case in same cell. Is it can done by automatic?
    any want can help me

  2. #2
    Forum Contributor
    Join Date
    11-05-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    229

    Re: how to change Lower case to capital case in same cell

    Hi!
    Welcome to the forum!

    What you are asking cannot be done in the same cell using a formula. You would have to use VBA macros. Ask your question in the VBA part of this forum, they will help you out.
    Taming the Excel dragon... www.TheExcelphile.com

  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: how to change Lower case to capital case in same cell

    Instead of asking the same question in another subforum, its better to PM a mod to move the thread to that subforum. Alternatively, you can click the triangle with the ! mark and report the post asking for it to be moved.

    If you create the same thread in a different subforum, it will be flagged as duplicate and you stand a chance of reducing your points.

    I will move this thread for you today.
    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]

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: how to change Lower case to capital case in same cell

    Ucase(range("A1"))

+ 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