Question: 2 . 3 Use the LEFT function in cell C 5 to return the text Employee number from the Text Stamp Phrase in cell Notice
Use the LEFT function in cell C to return the text "Employee number" from the "Text Stamp Phrase" in cell Notice the space after number.
a Use a reference to the location of the # symbol in cell C as the numchars argument.
b Since the # symbol is one character past the text you want to return, you will need to adjust the numchars argument by subtracting from the reference to cell C
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
