REGEXREPLACE
Replaces text that matches the pattern.
REGEXREPLACE(text, regular_expression, replacement, [occurence], [case_sensitivity])
text - The text, a part of which will be replaced.
regular_expression - The regular expression. All matching instances in text will be replaced.
0: Case Sensitive1: Case Insensitive
Examples
Formula | Result |
=REGEXREPLACE("Hello 123"; "[0-9]+"; "000") | Hello 000 |
= REGEXREPLACE(A3; "[0-9]*\.[0-9]+[0-9]+"; "15.75")
| Bag weight is 15.75 kgs |
=REGEXREPLACE(A4; "\(([A-Za-z]+)\)"; C4) | Content in brackets |
Get a hands-on experience of the function in the embedded range below.
Errors | Meaning |
#N/A! | The specified delimiter was not found in the given text string. The given instance value is higher than the total occurrences of the delimiter in the text string. |
#NAME! | The function name is incorrect or invalid. The given defined name (if any) is invalid. There is a typo in the defined name used in the function. Double quotes are missing for text values in the function. Colon missing in a cell range reference. |
#VALUE! | The given argument's data type is incorrect or invalid. The given instance value is 0 or higher the length of the text string. |
#REF! | The given cell reference is incorrect or invalid. This error may occur when a cell/range has been deleted, moved, or pasted over. |
Similar Functions
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Create. Review. Publish.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
REGEXMATCH
Checks whether a piece of text matches a regular expression. Syntax REGEXMATCH(text, regular_expression, [case_sensitivity]) text: The text to be tested against the regular expression. regular_expression: The regular expression to test the text ...REGEXEXTRACT
Extracts text that matches the pattern. Syntax REGEXEXTRACT(text, regular_expression, [return_mode], [case_sensitivity]) text: The text given as input. regular_expression: The first part of text that matches this expression will be returned. ...