Thread: Proper Function
View Single Post
  #1  
Old July 7th, 2004, 09:28 PM
external usenet poster
 
Posts: n/a
Default Proper Function

Hi,

I have about 20 columns in an Excel spreadsheet that
contain name, address, etc. in various forms of
capitalization. I believe I can use the proper fucntion
to capitalize the first letter of each work and make all
other letters lowercase.

My question is how do I do this for a series of columns,
or selected columns all at one time. I see to be getting
an error message related to a circular pattern or
something like that

Any help is much appreciated

Thanks
Bill