You could -
import data into Word
<Edit<Select all<Format<Change case to change it into 'sentence
case' or 'lower case'.
import data back into Excel

You will need to check it over and correct any funnies but that will take
the hard work out of the operation.

Regards.

Bill Ridgeway
Computer Solutions

"Steve" wrote in message
...
Hi
I have a excel doc (2003 verson) which has names and addresses in
different
cells, all the text is in CAPS, i need it to be in Proper case. I have
tried
=Proper(cell) and it comes up with #vaule? I dont know what to do so any
suggestions would be most helpful.
Thanks in advance.
Steve