Which of the following functions is best suited to replace the word "Doctor" with "Dr." in a text string?
A)TRIM
B)LEFT
C)CONCATENATE
D)SUBSTITUTE

Question

Quizplus · Accepted Answer

The SUBSTITUTE function is best suited for replacing specific text within a text string, such as "Doctor" with "Dr." We can use the SUBSTITUTE function to replace all instances of "Doctor" with "Dr." in a text string.

Which of the Following Functions Is Best Suited to Replace