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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have wrongly typed in lower case, can I change it to upper case without
having to re-type everything?
 
=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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Upper / Lower Case 1
change to upper/lower case 1
convert lower to upper case automatically without using UPPER 6
lower case letter "i" always converts to upper case 1
Upper Case Conversion 4
CHANGE LOWER CASE TO UPPER CASE? 1
Format Cell - Only Upper Case Alpha characters 3
How do I convert addresses to all caps in Office 2007? 3

Back
Top