» Convert text to lower case in Microsoft Excel
CATEGORY - Excel Text , Working with Formulas
VERSION - 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
Book Store:
Recommended Books:
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Finance and Accounting for Nonfinancial Managers
- Microsoft Windows XP Inside Out
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Investing in Real Estate, Fourth Edition
Convert text case
Louis Pucilowski
Useless information. It does not work
CONVERT TEXT CASE
SUSIE
IT DOES WORK!!!
how can i convert a figure ino deno minations
ajaygopal
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
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
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.
