Basically you need to insert a temporary column and place the function:
=Proper( ) and copy it all the way down. highlight the results and click Copy
- Value - Esc. Highlight again and copy to the original name cells. Same
method for the addresses.
SUNAN

"Sagit" wrote:

I have a file of names and addresses that were entered in all upper case. Is
there a fast way to change this file into upper and lower case? Thanks for
any help you can give me.
--
S Jan