Changing capitalized words to smaller case

[ar]

I have worksheets that have words all capitalized and I paste it to a new worksheet. The new worksheet must have the words all in lower case except for the first letter of the word. Changing the words to smaller case will be time-consuming and was wondering if there is a feature that can change all the words to smaller case all at once.

 

[Mark W.]

Try using the PROPER worksheet function.

 

[AJ]

Simply use the formula

=LOWER(your cell here)

for lower case, and

=PROPER(your cell here)

for sentence case

Rgds
AJ

 

[ar]

Can you give me instructions for using the PROPER function? Also, there are 5 to 10 rows of capitalized words that I need to change to smaller case, not just one row. Thanks.

 

[Aladin Akyurek]

On 2002-04-02 09:41, ar wrote:
Can you give me instructions for using the PROPER function? Also, there are 5 to 10 rows of capitalized words that I need to change to smaller case, not just one row. Thanks.

In A1 enter: ar
In B1 enter: =PROPER(A1)

For the larger task you could better use ASAP-Utilities, a free download from:

http://www.asap-utilities.com