Remove text within brackets: Difference between revisions

From LemonWiki共筆
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) -> 國內生產...")
 
mNo edit summary
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 ==

Revision as of 15:56, 13 March 2023

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