View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

take a look he

http://www.mvps.org/dmcritchie/excel/proper.htm#proper

In article ,
"Tom III" <Tom wrote:

I purchased a rather large list that is in all caps (in .txt format). Is
there a function that will allow Excel (or any other Office product) to
automatically change the names to proper case? I will need to save the
results back in .txt format to import into a contact management program.