Remove text within brackets: Difference between revisions
Jump to navigation
Jump to search
| Line 4: | Line 4: | ||
== How to remove text within brackets/parentheses in Google sheets == | == How to remove text within brackets/parentheses in Google sheets == | ||
Before & After | Before & After removed the text within brackets/parentheses | ||
* 國內生產總值(GDP) -> 國內生產總值 | * 國內生產總值(GDP) -> 國內生產總值 | ||
* 國家情報總監（英語：Director of National Intelligence，簡稱DNI） -> 國家情報總監 | * 國家情報總監（英語：Director of National Intelligence，簡稱DNI） -> 國家情報總監 | ||
Latest revision as of 14:36, 14 March 2023
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, "([\(|（][^（|）|\(|\)]+[）|\)])", "")