B
betsy
is there an easy way to convert test from upper to lower
case?
Thanks
case?
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
J.E. McGimpsey
To modify existing cells in place, take a look at David McRitchie's
Lower() macro:
http://www.mvps.org/dmcritchie/excel/proper.htm#lower
To convert text in another location, use the LOWER() function, e.g.:
A1: UPPER
B1: =LOWER(A1) ===> upper
Lower() macro:
http://www.mvps.org/dmcritchie/excel/proper.htm#lower
To convert text in another location, use the LOWER() function, e.g.:
A1: UPPER
B1: =LOWER(A1) ===> upper
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.
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
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