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.

Notice the Excel limit:

• Nested 64 Substitute Formulas limit.
• Excel function limit 8192 character

PHP

PHP: preg_replace - Manual