on google sheets I am trying to remove some capital letters that exist between brackets using regexreplace

=arrayformula(regexreplace(regexreplace(A2:A,"\(. ?\)\ Ltd$| $| LTD$","")," $| LTD$",))

the only part remaining is where it could be random company (PTY) and I need to remove the space before the (PTY) and the (PTY).

any ideas?

CodePudding user response：

Try this formula:

=arrayformula(regexreplace(A2:A,"\s?\(. \) (Ltd|LTD)$",""))

Output:

Reference:

• Regex capturing group