Changing Case In Excel

Giganews Newsgroups
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
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

>-----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?
>.

Replies

None

In response to

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