Here is an Excel formula in cell A1. =LEFT(. (Hey man!, Hey, Hi), H, D), 2)...

 

Transcribed Image Text:

Here is an Excel formula in cell A1. =LEFT(. ("Hey man!", "Hey", "Hi"), "H", "D"), 2) A cell formula function has been used twice in the formula, as indicated in position X, and it is not shown above. Here is the output of cell A1. 1 Di What is the function used in the formula in position X so that it shows the above output as a result? You need to write the answer clearly in the box below. You only need to write the function name, using capital letters, in the answer. Activate Here is an Excel formula in cell A1. =LEFT(. ("Hey man!", "Hey", "Hi"), "H", "D"), 2) A cell formula function has been used twice in the formula, as indicated in position X, and it is not shown above. Here is the output of cell A1. 1 Di What is the function used in the formula in position X so that it shows the above output as a result? You need to write the answer clearly in the box below. You only need to write the function name, using capital letters, in the answer. Activate

Answer rating: 100% (QA)

This will be the SUBSTITUTE function The first ... View the full answer