What exactly is in your cell? What is the address? In which cell do you
enter what formula?

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"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