There is a built in function for that.

=Proper(A1)
--
HTH...

Jim Thomlinson


"klmiura" wrote:

Does anyone have a Macro that I can use to change the first letter of every
word in an excel cell to Capital?

For example I have cell A1 with the contents of: private hospital

I would like to run the Macro and the cell to say: Private Hospital

Thank you,
Karen