IN EXCEL, HOW DO I ALTER LOWER CASE TO UPPER NOT OVERTYPING

K

kkirstyy

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

Dave F

=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.
 
Top