Assuming you have text in A1 like john smith

In B1 enter =PROPER(A1)

Returns John Smith


Gord Dibben MS Excel MVP


On Mon, 30 Oct 2006 13:16:02 -0800, hornbss
wrote:

I have ready the posts regarding this subject. I'm an idiot evidentally.
Actually, i've never done this before.

I've tried entering the =PROPER(text) formula, nothing happens. I've tried
copying to VBA (which I don't even know what any of this means) nothing
happens. What is the quickest way to find a step by step solution for
DUMMIES?????