Change Case

[Hague2]

Does Excel have the feature of Changing Case (upper/lower) like Word?

 

[Don Guillett]

try looking in HELP index for CASE.

 

[Carlos Antenna]

=UPPER(a1)
=lower(a1)
=Proper(a1)

-- Carlos

 

[Shailesh Shah]

You can download one com-addins "change case in excel" for Excel-2000+ from
below site.

http://members.lycos.co.uk/shahweb/

It is the fourth download link and is below the 2nd .jpg (Letter Case).


Regards,
Shailesh Shah
http://members.lycos.co.uk/shahweb/
(Excel Add-ins)