changing case in excel

  • Thread starter Thread starter andre
  • Start date Start date
A

andre

Is there a way in excel to convert words to upper case
and from upper case to lower case
 
hi Andre
see your answer in Excel.worksheet.functions
P.S.: please don't multipost
 
In another cell
=UPPER(A1)
=LOWER(A1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top