Trying to remove all text within Parentheses and remove parentheses as well as well as Turn all the-CodePudding

I have a google sheet with a list of names that I am trying to apply my existing formula to. There are some names that have parentheses with text within those parentheses as well as some names that are all captial letters. I want to remove the parentheses and the text within as well having only the first letter of each name capitalized written into a formula. My existing formula removes the parenthese, dashes and quotation marks which I want to keep it that way, but now I am just wantint to add onto that formula all together for what I stated above. I will also link my practice google sheet so you can see where I am applying the formula.

Formula: =ARRAYFORMULA(TRIM(REGEXREPLACE(C4:C411,"-|'|,|(|)|"""," ")))

CodePudding user response：

try:

=INDEX(TRIM(REGEXREPLACE(REGEXREPLACE(A25:A28, 
 "['-]", " "), "[^A-Za-z ]", )))

you can add PROPER, LOWER or UPPER if you need so:

=INDEX(PROPER(TRIM(REGEXREPLACE(REGEXREPLACE(A25:A28, 
 "['-]", " "), "[^A-Za-z ]", ))))