Upper case to lower case

D

David McRitchie

Hi Betsy,
I guess the worksheet solution was written a bit hastily,
though you could have looked in HELP. And since you know
the answer now, definitely try to look in Help now to help you
out later on in looking up other things in HELP.

A1: 'Mixed Case
B1: =LOWER(A1)

You can use the fill handle or for a range use Ctrl+D to copy down
http://www.mvps.org/dmcritchie/excel/fillhand.htm

If you look at my web page that John mentioned:
Proper, and other Text changes -- Use of SpecialCells
http://www.mvps.org/dmcritchie/excel/proper.htm#lower
there are installation instructions at the top they refer to the web page
Getting Started with Macros and User Defined Functions
http://www.mvps.org/dmcritchie/excel/getstarted.htm

The big advantage of a macro is that you run it and you are done.
With worksheet formulas you have to go through extra gyrations
to eliminate the original column since your formula is dependent
upon the original. Spelled out at top of my proper.htm page.
 
D

David McRitchie

Hi Betsy,
I mean *now* that you know the answer --
LOWER Worksheet Function
you should look it up in Help.

F1 (Help), Index tab, PROPER Worksheet Function

Should be easy to find in help you are looking for
lowercase because that is what you want.

F1 (Help), Answer Wizard (tab),
lowercase
also not that if you are looking at
UPPER, PROPER, LOWER you could find the others
from their help with the "See Also" hyperlink.

More on worksheet functions:
I would suggest that you obtain the following and maintain it
on your computer for reference.

A reference to definitely download and maintain on your computer
Excel Function Dictionary -- by Peter Noneley
http://homepage.ntlworld.com/noneley
workbook with 157+ sheets, each with an explanation and example of an Excel function.

This is all worksheet functions, and of course, I am suggesting
that a macro would be faster, but you do want to know the basics
first. At least it will get you familiar with all the extra steps you
can save with a macro. For doing conversions
lowercase, propercase, uppercase using macros see
http://www.mvps.org/dmcritchie/excel/proper.htm
In fact since a macro is under your control you can make the
Proper (Titlecase) do more what you want like actually properly
capitalize people's names rather than just the first letter of
each word.

BTW, hope you picked up on use of the fill handle, because
such things are harder to find in help if you have no idea that
they might exist.
http://www.mvps.org/dmcritchie/excel/fillhand.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top