View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob76 Bob76 is offline
external usenet poster
 
Posts: 2
Default uppercase to lowercase

Hi,
How do I convert names from all uppercase to lowercase, but leave the first
letters of the names in uppercase? for example: SMITH, JOHN to Smith,
John. I have about 150 names i have to convert in Excel 2007 spreadsheet and
it's really tedious to do it one at a time. Hope someone can help....
Thanks a lot, Bob