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

Question

Quizplus · Accepted Answer

The SUBSTITUTE function can be used to replace a specific string within a text string. In this case, we can use SUBSTITUTE to replace "Doctor" with "Dr." within the text string. The other functions listed (UPPER, CONCATENATE, LOWER) do not serve this specific purpose.

Which of the Following Functions Is Best Suited to Replace