Thread: IN EXCEL, HOW DO I ALTER LOWER CASE TO UPPER NOT OVERTYPING
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
  
Posts: 2,574
Default IN EXCEL, HOW DO I ALTER LOWER CASE TO UPPER NOT OVERTYPING
=UPPER(A1) if the text is in A1 and you want everything upper case and
=PROPER(A1) if you want only the first letter capitalized.

"kkirstyy" wrote:

If I have wrongly typed in lower case, can I change it to upper case without
having to re-type everything?
Reply With QuoteReply With Quote