Remove text within brackets

From LemonWiki共筆
Revision as of 15:55, 13 March 2023 by Unknown user (talk) (Created page with "How to remove text within brackets/parentheses == How to remove text within brackets/parentheses in Google sheets == Before & After * 國內生產總值(GDP) -> 國內生產...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

How to remove text within brackets/parentheses

How to remove text within brackets/parentheses in Google sheets

Before & After

  • 國內生產總值(GDP) -> 國內生產總值
  • 國家情報委員會（NIC） -> 國家情報委員會

How to

  • =REGEXREPLACE(A1, "([\(|（][^（|）|\(|\)]+[）|\)])", "")

How to remove text within brackets/parentheses in Excel

Retrieved from "https://wiki.planetoid.info/index.php?title=Remove_text_within_brackets&oldid=23562"