how to change small letters to capital letters

[HOW TO CHANGE]

dear sir/madam,

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


regards,
BALU

 

[Steve T]

Check the Microsoft Excel help for the UPPER and LOWER functions.

Hope this helps.

 

[Shailesh Shah]

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)

 

[Roger Govier]

Hi
In addition to the responses you have already received, don't forget
=PROPER(A1)
which would change "this" to "This"