|
» 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.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.
Sponsors:
 |
Book Store:
Recommended Books:
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- The Ernst & Young Business Plan Guide
- The 11 Immutable Laws of Internet Branding
- Microsoft Excel 2002 Formulas (With CD-ROM)
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.
