REPLACE
Replaces part of a text string with another given text string.
Syntax
original_text: The text, part of which you want to replace. E.g. "Mick Foyd"
start_position: The position where the replacement should begin. E.g. 6
length: Length of the text to replace. E.g. 4
Remarks
-
Alternatively, you can also use the Replace option under the Insert menu.
Examples
|
Formula |
Result |
|
=REPLACE("Mick Foyd";6;4;"Floyd") |
Mick Floyd |
|
=REPLACE("abc2mail.com";4;1;"@") |
|
|
=REPLACE(2020;4;1;1) |
2021 |
Possible Errors
|
Errors |
Meaning |
|
#N/A! |
|
|
#NAME! |
|
|
#VALUE! |
|
|
#REF! |
|
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:
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
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
Find and replace data
To find particular data and replace it with another: Go to Home in the menu bar and tap Find & Select. Enter the data you wish to find in the sheet and tap Find. To find and replace the data, enter the actual data and the data to replace it with. You ...Find and replace data
1. Click on the Search bar on the right top corner. 2. Click on the drop down menu in the search bar, and from there choose More options. 3. Once this done, a Find and replace dialogue box will appear. 4. In the dialogue box, key in the word you are ...Find and replace values in a spreadsheet
To find and replace values in your spreadsheet: Go to the ... icon, then choose Find and Replace. Enter a value to search in the current worksheet. Navigate between the found values using the icons. Tap the icon to customize the search and to ...SUBSTITUTE
Replaces an existing text string with another given text string. Syntax SUBSTITUTE(original_text; old_text; new_text; [which]) original_text: The text to search for the given text string. E.g. "Zoho Sheet" old_text: The existing text string you ...Find and remove data inconsistencies
1. Click on the Data menu. 2. From the Data Cleaning option, select Fix Data Inconsistencies from the drop down. 3. In the data cleaning panel, choose a column from which you want the tool to pick the inconsistencies from. 4. The tool will list down ...