Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

Changing All Caps to Upper and Lower

Posted by Karen on August 09, 2001 9:42 AM
I need help changing a spreadsheet containing all caps text to upper and lower case. Does anyone know the best formula? I know about using the "Proper" function, but I keep getting circular errors and other problems.

Thanks.


Re: Changing All Caps to Upper and Lower

Posted by Mark W. on August 09, 2001 9:49 AM
Take a look at the Text menu of ASAP Utilities'
freeware add-in at www.asap-utilities.com.


Re: Changing All Caps to Upper and Lower

Posted by Aladin Akyurek on August 09, 2001 9:50 AM

I guess you mean something like

UPPER --> Upper

If so, use

=LEFT(A1)&LOWER(MID(A1,2,LEN(A1)))

Aladin


Re: Changing All Caps to Upper and Lower

Posted by Aladin Akyurek on August 09, 2001 9:53 AM

ASAP Utilities would be just fine. However, why do you have problems with PROPER?

=PROPER(A1), entered in B1 should work.


Aladin


Re: Changing All Caps to Upper and Lower

Posted by KAREN on August 09, 2001 12:25 PM
Thanks for help. ASAP Utilities workS great.

Re: Changing All Caps to Upper and Lower

Posted by Karen on August 09, 2001 12:35 PM
Thanks for help. ASAP Utilities works great.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.