Proper and apostrophes

[frinholp]

Hi all

I am trying to create a function similar to Proper but the difference being if a space is followed by an apostrophe then a character, I do not wish the character to be changed to uppercase.

I am trying to avoid recursion but everything I have tried has a 'knock-on effect' when the apostrophe is used in a different way.

Any ideas?

Thanks in advance

Lee

[comment]

Not sure what you mean by 'knock-on effect'. It's possible to have Proper() NOT change characters preceded by a space and an apostrophe to uppercase - but then it WILL change them to lowercase.