Tags: capital, dear, excel, madam, microsoft, msdn, regards, sir, software

how to change small letters to capital letters

On Microsoft » Microsoft Excel

2,234 words with 4 Comments; publish: Thu, 22 May 2008 07:23:00 GMT; (30693.75, « »)

dear sir/madam,

how to change small letters into capital letters or capital letters into

small letters.

regards,

BALU

All Comments

Leave a comment...

  • 4 Comments
    • Check the Microsoft Excel help for the UPPER and LOWER functions.

      Hope this helps.

      "HOW TO CHANGE" wrote:

      > dear sir/madam,

      > how to change small letters into capital letters or capital letters into

      > small letters.

      >

      > regards,

      > BALU

      #1; Thu, 22 May 2008 07:25:00 GMT
    • Hi Balu,

      You may find several methods\free add-ins via google search and also check

      back later for your post.

      To find within excel, you may download Google search addins by Ron from

      below site.

      http://www.rondebruin.nl/Google.htm

      BTW in case you want to use addins, you may download my free com-addins

      "change cell case" from below site

      http://in.geocities.com/shahshaileshs/

      Regards,

      Shailesh Shah

      http://in.geocities.com/shahshaileshs/

      (Excel Add-ins Page)

      "HOW TO CHANGE" wrote:

      > dear sir/madam,

      > how to change small letters into capital letters or capital letters into

      > small letters.

      >

      > regards,

      > BALU

      #2; Thu, 22 May 2008 07:26:00 GMT
    • Hi Balu,

      formula: to change from capital letters to small letters =lower()

      to change from small letters to capital letters =upper()

      (put the cell in the () e.g. =lower(A1)

      Austuni

      "HOW TO CHANGE" wrote:

      > dear sir/madam,

      > how to change small letters into capital letters or capital letters into

      > small letters.

      >

      > regards,

      > BALU

      #3; Thu, 22 May 2008 07:27:00 GMT
    • Hi

      In addition to the responses you have already received, don't forget

      =PROPER(A1)

      which would change "this" to "This"

      --

      Regards

      Roger Govier

      "HOW TO CHANGE" <HOW TO CHANGE.excel.questionfor.info.discussions.microsoft.com> wrote in

      message news:20009B53-4F00-47B9-B21B-952D199741D7.excel.questionfor.info.microsoft.com...

      > dear sir/madam,

      > how to change small letters into capital letters or capital letters

      > into

      > small letters.

      >

      > regards,

      > BALU

      #4; Thu, 22 May 2008 07:28:00 GMT