View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
austuni austuni is offline
external usenet poster
 
Posts: 4
Default 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