Since I think you would really prefer Proper case rather
than lower case see
http://www.mvps.org/dmcritchie/excel/proper.htm

You then also have the ability to capitalize words closer
to how titles are capitalized an how people's last names
are actually capitalized. i.e. David McRitchie
You would have to tweak it slightly to match your experience,
as not everyone capitals their names the same.
---
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

"RuBarb" wrote in message
...

I am a new user. I have a new excel document that has two columns:

First Name and Last Name. Under the "First Name" column, I have a list
of 200 names in all caps. The same in the "Last Name" column. How do I
convert the names to lower case (or initial caps and then lower case).
I looked it up in the help menu, but I don't understand how to use a
"function". Any help would be appreciated so that I don't have to rekey
the names. Please be very specific since I am a new user. Thanks so
much!


--
RuBarb
------------------------------------------------------------------------
RuBarb's Profile: http://www.excelforum.com/member.php...o&userid=30747
View this thread: http://www.excelforum.com/showthread...hreadid=504133