Remove text within brackets
Jump to navigation
Jump to search
How to remove text within brackets/parentheses 移除刮號內的文字
How to remove text within brackets/parentheses in Google sheets[edit]
Before & After removed the text within brackets/parentheses
- 國內生產總值(GDP) -> 國內生產總值
- 國家情報總監(英語:Director of National Intelligence,簡稱DNI) -> 國家情報總監
- 國家情報委員會(NIC) -> 國家情報委員會
How to
- =REGEXREPLACE(A1, "([\(|(][^(|)|\(|\)]+[)|\)])", "")