Regular replace string
Jump to navigation
Jump to search
"Replaces part of a text string with a different text string using regular expressions."
Google Sheet[edit]
- REGEXREPLACE - 文件編輯器說明 in Chinese
- REGEXREPLACE - Docs Editors Help in English
Notice the Google Sheet limit:
- Maximum string length is 50,000 characters in one cell[1]
Excel[edit]
Regular expression was not supported well on Excel. Using the SUBSTITUTE 函數 - Office 支援 function instead.
Notice the Excel limit:
- Nested 64 Substitute Formulas limit.
- Excel function limit 8192 character[2]