|Subject:||Changing Case In Excel|
|Posted by:||lynn hwee (hwee…@hotmail.com)|
|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.
>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?
Changing Case In Excel posted by mikmahone on Wed, 8 Oct 2003