{"id":33786,"date":"2021-01-23T13:00:00","date_gmt":"2021-01-23T13:00:00","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=33786"},"modified":"2021-01-23T13:00:01","modified_gmt":"2021-01-23T13:00:01","slug":"replace-function","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/replace-function\/","title":{"rendered":"Replace Function"},"content":{"rendered":"\n

REPLACE function is used to replace part of a text string, depending on the number of characters you specify, with a different text string.<\/p>\n\n\n\n

Syntax<\/strong><\/h4>\n\n\n\n
REPLACE(<old_text>, <start_num>, <num_chars>, <new_text>)  \n<\/code><\/pre>\n\n\n\n
Defined Parameters<\/strong><\/h4>\n\n\n\n
Term<\/th>Definition<\/th><\/tr><\/thead>
old_text<\/td>It represents the string of text containing the characters you want to replace, or a reference to a column that contains text.<\/td><\/tr>
start_num<\/td>It represents the position of the character in\u00a0old_text<\/strong>\u00a0that you want to replace with\u00a0new_text<\/strong>.<\/td><\/tr>
num_chars<\/td>It represents the number of characters that you want to replace.\u00a0

Warning:\u00a0If the argument,\u00a0num_chars, is blank or references a column that evaluates to a blank, the string for\u00a0new_text<\/em>\u00a0is inserted at the position,\u00a0start_num<\/em>, without replacing any characters. It has the same behavior as in Excel.<\/td><\/tr>
new_text<\/td>It represents the replacement text for the specified characters in\u00a0old_text<\/strong>.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
Return value<\/strong><\/h4>\n\n\n\n
It represents a text string.<\/p>\n\n\n\n
Note – <\/strong><\/h4>\n\n\n\n