how to change small letters to capital letters
 

dear sir/madam,

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


regards,
BALU

how to change small letters to capital letters
 

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

how to change small letters to capital letters
 

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

how to change small letters to capital letters
 

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

how to change small letters to capital letters
 

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 wrote in
message ...
dear sir/madam,

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


regards,
BALU