need VBA to Cap first letter in each cell in one column

[skyport]

As always I return to the great resource of Mr. Excel on this one.

I have column G on sheet 2 which will have data inputted. The first letter in each cell in column G needs to be upper case but done in a manner that does not eliminate the existing caps to other words in the sentence within the cells.

EXAMPLE: my impression is that Mary is the right choice for Montana.

The result should cap the word "my" but still also leave Mary and Montana in upper case.

The reason this needs to be a VBA and not a formula is because the cells in column G already contain a formula for another purpose.

Can anyone help with this one pleae?

 

[hiker95]

Hiker 95, thanks again, the code worked perfect. Always good to see you again with great solutions.

skyport,

Thanks for the feedback.

You are very welcome. Glad I could help again.

And, come back anytime.