VB Code to convert to 1st Capital in a word

[rizmomin]

hello:

Please refer to attached file.
I need VB Code to convert data in Column B as follows:
1stg Letter of Word Capital.
Some examples are shown in column C.
Let me know if you have any questions.
Thanks.

Riz

[nankw83]

Hi Riz,

Try below code ...

Please Login or Register  to view this content.

[maras_mak]

Try.

Please Login or Register  to view this content.

[rizmomin]

Hello Maras

It works great, however the actual data is part of large worksheet with data in other columns.
These data are in column D so i need your help to modify above code so that i overwrites corrected data in same column

Once again thanks

PS : YOUR CODE IS GICING RESULT AS ATTACHED...

Riz

[nankw83]

I just noticed that you have MS Off. Ver. 2010 so my code in post #2 may not give you the expected results, try modified code below ...

Please Login or Register  to view this content.

[rizmomin]

Hello nankw83..

Yes your code works great.

Thanks

Riz

[nankw83]

Glad to help & thanks for the added Rep+

[maras_mak]

Corrected code.

Please Login or Register  to view this content.