how can I change case to Proper on a worksheet

[PlsHelp]

I have an excel file that is all caps and want to change the case to proper

[foxxkat]

=PROPER()

A1
WASHINGTON

=PROPER(A1)

returns

Washington

[JE McGimpsey]

Take a look here:

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

In article <[email protected]>,
"PlsHelp" <[email protected]> wrote:

> I have an excel file that is all caps and want to change the case to proper

[rosalindvt]

You can also export to a .CSV, open the .CSV in MS Word, Use "Change Case" to
change to Title Case, and then re-import into Excel.

"PlsHelp" wrote:

> I have an excel file that is all caps and want to change the case to proper