Question: Use the MID function in cell C12 to return the text entered the server room at (notice the spaces at the beginning and
Use the MID function in cell C12 to return the text " entered the server room at " (notice the spaces at the beginning and end of the phrase) from the "Text Stamp Phrase" in cell C7. Use a reference to the location of the "#" symbol in cell C9 as the "start_num" argument. Since the "#" symbol is 1 character before the text you want to return, you will need to adjust the "[num_chars]" argument by adding 1 to the reference to cell C9. Use the difference between the location of the "#" symbol and the characters " HH" as the "num_chars" argument.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
