Thread: CHANGE ALL CAPS TO LOWER CASE WITHOUT TYPING
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default CHANGE ALL CAPS TO LOWER CASE WITHOUT TYPING
In anotehr column apply the below formula and copy down as reuauired. Once
done copyPasteSpecialValues to convert formulas to values...

=LOWER(A1)
--
Jacob


"MAXXMAS" wrote:

I HAVE A COL OF NAME IN ALL CAPS. CAN THEY BE CHANGED TO LOWER CASE WITHOUT
HAVING TO TYPE IT OVER AGAIN. TKS
Reply With QuoteReply With Quote