Using Proper case and avoiding the capital letter after an apostrophe....

[CDandVinyl]

I use this code to change the text in G3 to proper case :

Please Login or Register  to view this content.

It works fine , but always give a capital S after an apostrophe.

For example ;

John's becomes John'S

Helen's becomes Helen'S

Can someone suggest a modification to my code to correct this please , so that the 'S' after the apostrophe becomes 's'?

Grateful for any advice.

[jindon]

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[:) Sixthsense :)]

Replace this line

Please Login or Register  to view this content.

With

Please Login or Register  to view this content.

[CDandVinyl]

Many thanks guys. That's fixed it.

Problem solved!