Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Convert all caps to lower case
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Convert all caps to lower case
Try this, Barb:
http://www.officearticles.com/excel/...ft_exce l.htm ************ Hope it helps! Anne Troy www.OfficeArticles.com "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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Convert all caps to lower case
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Convert all caps to lower case
Thanks to both of you for your replies. I have already used them and they work great! Thanks again! -- RuBarb ------------------------------------------------------------------------ RuBarb's Profile: http://www.excelforum.com/member.php...o&userid=30747 View this thread: http://www.excelforum.com/showthread...hreadid=504133 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert numbers to text | Excel Discussion (Misc queries) | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions |