View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default 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