Hi Guys,
I'm looking for a solution to automatically change names' first letters to capital letters, but with some exceptions. I know that PROPER formula would do that, but let's say I have many names with de, da etc., like Marco da Costa, is there any chance then to write the formula in the way so in case there are 3 name components, they will keep the 2nd in lower cases, but when it's like Marco Costa, then it will keep it both with capital letters? I hope it makes sense. Thank you!
Bookmarks