I have attached a file for which I am trying to format lower case names to proper name including the mcc.. to McC.. and o'b.. to O'B..
Any help appreciated
Don't see the problem, see attach
You are not using the Proper function correctly. I revised your file using a Case statement. You can add to the Case statement to cover more possibilities.
Thanks for both your responses
I do like the use of the Case statement as suggested as their are more variables for surnames to take into account
Although, when I start looking at surnames i.e. "van der Wilke" or "de Sorte" - I presume the use of "x = Length (name) -2" would need to be modified with another Case statement to cover more variables?
You would need to modify the calc. I would think that you could probably find on the Internet a custom function to do this.
Retrieving data ...