MyEducator Tasks

$2\mathrm{.}3$ Use the LEFT function in

$2\mathrm{.}4$ Use the SEARCH function in cell C$6$ to determine the position of the characters $"H{H}^{\text{'}\text{'}}($notice the space before the first H$)$ in the "Text Stamp Phrase" in cell C$2.$

$6$

$2\mathrm{.}5$ Use the MID function in cell $C7$ 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 $($C$2.$

a$.$ Use a reference to the location of the $"$#$"$ symbol in cell $($C$4)$ as the "start num" argument.

b$.$ Since the $"$#$"$ symbol is $1$ character before the text you want to return, you will need to adjust the $"[$start$\_$num$]"$ argument by adding $1$ to the reference to cell C$4.$

c$.$ Use the difference between the location of the $"$#$"$ symbol $($cell C$4)$ and the characters" $H{H}^{\text{'}\text{'}}($cell C$6)$ as the $-$ "num$\_$chars" argument.