Thread: How to change case in excel? MS Help is no help
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
  
Posts: 2,574
Default How to change case in excel? MS Help is no help
Use the function PROPER.

If your text string is in A1, then =PROPER(A1) will yield proper case.
--
Brevity is the soul of wit.


"philippos" wrote:

I want to be able to change capital letters into title case. A colleague and
I have
tried to follow the instructions given by the online Help but cannot figure
out how to make this work. The instructions are not very well explained
Reply With QuoteReply With Quote