|
» Convert text to lower case in Microsoft Excel
CATEGORY: Excel Text , Working with Formulas |
VERSIONS: All Microsoft Excel Versions |
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 |
  |
|
RATING:
3.24
VIEWS: 71001 |
||||
Convert text case
Louis Pucilowski wrote on December 31, 1969 19:00 EST
Useless information. It does not work
CONVERT TEXT CASE
SUSIE wrote on December 31, 1969 19:00 EST
IT DOES WORK!!!
how can i convert a figure ino deno minations
ajaygopal wrote on December 31, 1969 19: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 19: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 19: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.
Sponsors:
 |
Book Store:
Recommended Books:
- Microsoft Office XP Introductory Concepts and Techniques
- Yes, You Can Time the Market!
- The Analysis and Use of Financial Statements
- Excel Charts
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- The Intelligent Investor: The Classic Bestseller on Value Investing
Related MS EXCEL TIPS:
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.
