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

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

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

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

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