The _____ function replaces text in a text string.
A) REPLACE
B)SEARCH & REPLACE
C)SUBSTITUTE
D)STRING

Question

The _____ function replaces text in a text string.​
A) REPLACE
B)SEARCH & REPLACE
C)SUBSTITUTE
D)STRING

Quizplus · Accepted Answer

The SUBSTITUTE function replaces specific text in a specified text string with new text. The REPLACE function is similar but replaces text based on a specific location in the string, not just the content. "SEARCH & REPLACE" is not a specific Excel function. "STRING" is a data type and not a function in Excel.

The _____ Function Replaces Text in a Text String