Regular replace string

"Replaces part of a text string with a different text string using regular expressions."

Google Sheet

• REGEXREPLACE - 文件編輯器說明 in Chinese
• REGEXREPLACE - Docs Editors Help in English

Excel

Not support regular expression on Excel. Using the SUBSTITUTE 函數 - Office 支援 function instead. Nested 64 Substitute Formulas limit.

PHP

PHP: preg_replace - Manual