Hi,
I currently run a vba script that looks at a column of last names and runs the proper function. While doing so it also looks for names like McDonald and ensures the 'D' is upper case.
my current script works perfectly.
my new issue is a name such as wagland-mcdonald - my result im getting...