Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004

    Unanswered: Help making a column all caps

    I know in Word you can highlight and go to format--> fonts and choose for the letters to be all CAPS. Only when I highlight in excel and go to format and font... there is not a check box to make all the letters caps. Is there another way to do this? Thanks!

  2. #2
    Join Date
    Dec 2003
    San Diego, CA
    Try =UPPER(Range)

    There is also a Text Converter function that Ivan F. Moala wrote that I'm attaching.

    Hope that helps,

    Attached Files Attached Files

  3. #3
    Join Date
    Jun 2004
    Textbox1= StrConv(Textbox1, vbProperCase) Capitalize first Letter Of Word
    Textbox1= StrConv(Textbox1, vbLowerCase) Lower Case Whole Word
    Textbox1= StrConv(Textbox1, vbUpperCase) Capitalize Whole Word

Posting Permissions

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