View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default change font from all capitals?

Uset the formula
=Lower(A1)

--
HTH...

Jim Thomlinson


"jumbiegirl" wrote:

I have a spreadsheet from someone and it's all in CAPS. i want to change all
the font to lower case. Is there a way.