Upper case to lower case

is there an easy way to convert test from upper to lower
case?

Thanks

betsy

Use
=LOWER()

Andy
"betsy" wrote in message
...
is there an easy way to convert test from upper to lower
case?

Thanks

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



In article ,
"betsy" wrote:

is there an easy way to convert test from upper to lower
case?

Thanks

THanks guys, but I'm not familiar with macros. where or
how would I insert the =lower(). I've tried several
things like function but it doesn't work at least for me!

Betsy

-----Original Message-----
is there an easy way to convert test from upper to lower
case?

Thanks
.

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Betsy" wrote in message ...
THanks guys, but I'm not familiar with macros. where or
how would I insert the =lower(). I've tried several
things like function but it doesn't work at least for me!

Betsy

-----Original Message-----
is there an easy way to convert test from upper to lower
case?

Thanks
.

Thank you David. I've never done a macro, as I said
before, and I spent hours in HELP but it doesn't have
anything on how to convert UPPER CASE to LOWER CASE.

Thanks for taking the time.

Betsy
-----Original Message-----
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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed
Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm

"Betsy" wrote in message
...
THanks guys, but I'm not familiar with macros. where or
how would I insert the =lower(). I've tried several
things like function but it doesn't work at least for
me!

Betsy

-----Original Message-----
is there an easy way to convert test from upper to
lower
case?

Thanks
.



.

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

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Betsy" wrote in message ...
Thank you David. I've never done a macro, as I said
before, and I spent hours in HELP but it doesn't have
anything on how to convert UPPER CASE to LOWER CASE.

Thanks for taking the time.

-----Original Message-----

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