Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Toggle Caps, TitleCase, LowerCase... (Excel 2002 SP3)

    Is there someway to use a command similar to Shift F3 in Word which toggles between Sentence Case, lowecase, UPPERCASE, Title Case, and tOGGLE cASE in Excel?

    Thanks.
    Pooja

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Toggle Caps, TitleCase, LowerCase... (Excel 2002 SP3)

    There is not equivalent in Excel. The best you can do is use one of the functions - LOWER, UPPER, or PROPER.
    Legare Coleman

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Toggle Caps, TitleCase, LowerCase... (Excel 2002 SP3)

    The command in Word only toggles between Sentence case, UPPER CASE and lower case. There is no built-in equivalent in Excel, but you can store the macro from <post#=69696>post 69696</post#> in your Personal.xls and assign it to a keyboard shortcut and/por custom toolbar button. The rest of the thread may also be useful.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Toggle Caps, TitleCase, LowerCase... (Excel 2002 SP3)

    Pooja

    Have a look at this link, it shows how you can do this

    http://www.aicpa.org/pubs/jofa/feb2005/tech_qa.htm
    Jerry

  5. #5
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Toggle Caps, TitleCase, LowerCase... (Excel 20

    Thank you all!

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Toggle Caps, TitleCase, LowerCase... (Excel 2002 SP3)

    This is an ancient little add-in I use.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Toggle Caps, TitleCase, LowerCase... (Excel 2002 SP3)

    You can add a macro to a command button using the code below, but this only toggles between UPPER, LOWER and Proper Case:

    Sub SwitchCase()
    Dim Cell As Range
    For Each Cell In Selection
    Select Case Cell
    Case LCase(Cell) 'It's lowercase
    Cell = UCase(Cell)
    Case UCase(Cell) 'It's uppercase
    Cell = Application.Proper(Cell)
    Case Else 'It's neither upper nor lower
    Cell = LCase(Cell)
    End Select
    Next
    End Sub
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  8. #8
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Toggle Caps, TitleCase, LowerCase... (Excel 2002 SP3)

    Of course another method is to press F2 and copy the test in the cell (not the cell itself!)...paste it into Word, change the case there...and then copy it back into Excel again! Its a bit more tedious...but quite possible if for only a couple of cells of info!!!
    Regards,
    Rudi

Posting Permissions

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