Changing Case In Excel

  • Thread starter Thread starter mikmahone
  • Start date Start date
M

mikmahone

If you type in the wrong case in word, you can hit shift
F3 and it changes the case (e.g. lower to caps etc). Is
there any way to do this in Excel?
 
If your text is in say, A1. At a different cell, say
B1,you can use the following formula:
1) to change the string to upper case: =upper(cell
reference)
2) to change the string to lower case: =lower(cell
refernce)
3) to change the string to sentence case: =proper(cell
reference)

Then copy and paste value of B1 to remove the formula.

Lynn
 
Back
Top