Thread: Convert SMITH to Smith and JONES to Jones?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robert Judge Robert Judge is offline
external usenet poster
  
Posts: 24
Default Convert SMITH to Smith and JONES to Jones?
I have a big worksheet containing last names with all capitol letters. I
would like to convert the case of the names so that SMITH will become Smith
and JONES will become Jones. How can I accomplish this? I will appreciate
advice.
Reply With QuoteReply With Quote