Regular replace string: Difference between revisions
Jump to navigation
Jump to search
m (→Excel) |
mNo edit summary |
||
| Line 4: | Line 4: | ||
* [https://support.google.com/docs/answer/3098245?hl=zh-Hant REGEXREPLACE - 文件編輯器說明] in Chinese | * [https://support.google.com/docs/answer/3098245?hl=zh-Hant REGEXREPLACE - 文件編輯器說明] in Chinese | ||
* [https://support.google.com/docs/answer/3098245?hl=en REGEXREPLACE - Docs Editors Help] in English | * [https://support.google.com/docs/answer/3098245?hl=en REGEXREPLACE - Docs Editors Help] in English | ||
{{exclaim}} Notice the Google Sheet limit: | |||
* Maximum string length is 50,000 characters in one cell<ref>[https://gsuitetips.com/tips/sheets/google-spreadsheet-limitations/ Sheets Tips - Google Sheets Tips and Tricks | G Suite Tips]</ref> | |||
== Excel == | == Excel == | ||
Revision as of 11:34, 6 August 2019
"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
Notice the Google Sheet limit:
- Maximum string length is 50,000 characters in one cell[1]
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[2]