Changing word case in Excel doc

[Brent]

I have an Excel doc in which some words appear in all caps; others all lower
case; and other done properly. How do I quickly change the case writing in
the entire doc to proper?

[Paul B]

Brent, have a look here for a macro to do it

http://www.xcelfiles.com/VBA_Quick16.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Brent" <Brent@discussions.microsoft.com> wrote in message
news:E30AD73E-8ADF-488E-A63F-255A850F7F1A@microsoft.com...
>I have an Excel doc in which some words appear in all caps; others all
>lower
> case; and other done properly. How do I quickly change the case writing
> in
> the entire doc to proper?

[rosalindvt]

You can also save as a .CSV and then open it in MS Word. Use the "Change
Case" format option to change to title case (or whatever case you choose.)
Save the file again, and then re-import into Excel.

"Brent" wrote:

> I have an Excel doc in which some words appear in all caps; others all lower
> case; and other done properly. How do I quickly change the case writing in
> the entire doc to proper?