To change the word apple with orange in a string of text,use the ________ function.
A)SUBSTITUTE
B)PROPER
C)CONCATENATE
D)REPLACE

Question

Quizplus · Accepted Answer

The SUBSTITUTE function is used to replace existing text with new text in a string. The REPLACE function also changes text, but it requires position and length of the text to be replaced, making SUBSTITUTE the more straightforward choice for this specific task.

To Change the Word Apple with Orange in a String