View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Attman68 Attman68 is offline
external usenet poster
 
Posts: 4
Default decap names from transferred data

I wanted to sharpen my question a bit. I'm trying to apply PROPER to my
entire Excel table. Right now, I'm doing one column at a time, but I'd like
to find a way to select the entire table and have the PROPER function apply
proper text capitalization to any data field that has such text. Is there a
way to do that? Thanks!

"goathead" wrote:

How do I decap names that come across in all capital letters when I transfer
data.
I am usinga csv format.