Changing Case In Excel

Giganews Newsgroups
Subject: Changing Case In Excel
Posted by:  lynn hwee (hwee…
Date: Wed, 8 Oct 2003

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
2) to change the string to lower case: =lower(cell
3) to change the string to sentence case: =proper(cell

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


>-----Original Message-----
>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?



In response to

Changing Case In Excel posted by mikmahone on Wed, 8 Oct 2003