Im using the same formula, but its a mail merg document (20 Pages). All
feilds have quotes so it reads "STEVE", could this be the rreason why it wont
work?

"Roger Govier" wrote:

What formula are you using?
If I enter "roger govier" in cell A1 (without quotes) then in cell B1
=PROPER(A1)
returns Roger Govier

--
Regards
Roger Govier
"Steve" wrote in message
...
I need to use this formula for a mail merg document in excel 2003. I know
how
to write the formula but it wont work, it keeps coming up with Error
Vaule.
Does anyone know whats causing this and more important how to get round
it?