Google Exceltip.com
Account Icon
Shopping Cart
CheckOut

» Convert text to lower case in Microsoft Excel




 
Text in Upper case:            C:\MY DOCUMENTS\EXCELTIP.XLS

The Function:                  =LOWER(A1)

Result - Text in Lower case :  c:\my documents\exceltip.xls
Screenshot // Convert text to lower case in Microsoft Excel

Convert text to lower case in Microsoft Excel
Rate this tip
12 34 5
  RATING: 3.21
  VIEWS: 61451
Convert text case
Louis Pucilowski wrote on December 31, 1969 18:00 EST
Useless information. It does not work
CONVERT TEXT CASE
SUSIE wrote on December 31, 1969 18:00 EST
IT DOES WORK!!!
how can i convert a figure ino deno minations
ajaygopal wrote on December 31, 1969 18:00 EST
can u help me by providing a formula in excel
I want to convert 8785 DHS (UAE_
to how many 1000 currency req
how many 500 currency req
how many 100 currency
and how many 50, 20,10,5 and coins
Convert upper case to proper casing
Sue wrote on December 31, 1969 18:00 EST
I agree with Louis this is useless information. Can not get the function to place the proper text into the cell. I only receive the formula in the new cell.
Convert text to lower case
Tracy wrote on December 31, 1969 18:00 EST
It DOES work, but only one cell at a time. Start by clicking in a blank cell. Follow instructions as above. Once you have the converted information in the formerly blank cell, you can copy the new info and use "paste values" to paste it in the cell you want. That will eliminate the formula showing up in the formula bar.



REGISTERED USERS click here to post comments


GUESTSclick here to Register
Name
Comment Title
Comments


Terms and Conditions of use
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Copyright © 2003 ExcelTip.com
Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation