Changing capitalized words to smaller case

ar · Apr 2nd, 2002, 10:17 AM

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. · Apr 2nd, 2002, 10:18 AM

Try using the PROPER worksheet function.

AJ · Apr 2nd, 2002, 10:19 AM

Simply use the formula

=LOWER(your cell here)

for lower case, and

=PROPER(your cell here)

for sentence case

Rgds
AJ

ar · Apr 2nd, 2002, 10:41 AM

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 · Apr 2nd, 2002, 01:11 PM

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 10:17 AM	#1
ar New Member Join Date: Mar 2002 Posts: 24	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.

Apr 2nd, 2002, 10:18 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Try using the PROPER worksheet function.

Apr 2nd, 2002, 10:19 AM	#3
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	Simply use the formula =LOWER(your cell here) for lower case, and =PROPER(your cell here) for sentence case Rgds AJ

Apr 2nd, 2002, 10:41 AM	#4
ar New Member Join Date: Mar 2002 Posts: 24	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.