USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Peter wnats to replace a specific text in a text string in his spreadsheet. What function should he use?
|
|
FIND
|
|
|
SUBSTITUTE
|
|
|
VLOOKUP
|
|
|
SEARCH
|
Explanation:
Detailed explanation-1: -Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.
Detailed explanation-2: -REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string.
Detailed explanation-3: -Summary. The Excel SUBSTITUTE function replaces text in a given string by matching. For example =SUBSTITUTE("952-455-7865", "-", "") returns “9524557865"; the dash is stripped. SUBSTITUTE is case-sensitive and does not support wildcards.
There is 1 question to complete.