DATABASE FUNDAMENTALS
WORKBOOK THEMES
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Operation in Excel to replace cell content only.
|
Fill
|
|
Flash Fill
|
|
Paste Special
|
|
Replace Data
|
Explanation:
Detailed explanation-1: -=REPLACE(old text, start num, num chars, new text) The REPLACE function uses the following arguments: Old text (required argument) – This is the text we wish to replace some characters. Start num (required argument) – The position, within old text, of the first character that you want to replace.
There is 1 question to complete.