Remove text within brackets: Difference between revisions
Jump to navigation
Jump to search
(Created page with "How to remove text within brackets/parentheses == How to remove text within brackets/parentheses in Google sheets == Before & After * 國內生產總值(GDP) -> 國內生產...") |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
How to remove text within brackets/parentheses | How to remove text within brackets/parentheses | ||
移除刮號內的文字 | |||
== 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） -> 國家情報總監 | |||
* 國家情報委員會（NIC） -> 國家情報委員會 | * 國家情報委員會（NIC） -> 國家情報委員會 | ||
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, "([\(|（][^（|）|\(|\)]+[）|\)])", "")