Hi Sagit,
What do you mean by a file? In any case you want to change the
values in place with a macro and be done with it without having to clean
up afterwards and with the ability to handle 256 columns which I hope
you would not really need but it's the principle.

To convert a selection on a worksheet see upper_case macro at
http://www.mvps.org/dmcritchie/excel/proper.htm#upper

You can select an entire column from the activecell with ctrl+spacebar,
or click on the column letter..
You can select the entire sheet with ctrl+shift+spacebar
otherwise known as ctrl+a except to those on Excel 2003
or click on th gray button between row and column headers

If by file you mean all cells in all worksheets in your workbook, see
http://www.mvps.org/dmcritchie/excel/proper.htm#kindy
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Sunantoro" wrote in message ...
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