MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.

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.

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

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

Posted by KAREN on August 09, 2001 12:25 PM

Thanks for help. ASAP Utilities workS great.

Posted by Karen on August 09, 2001 12:35 PM

Thanks for help. ASAP Utilities works great.