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

2.3 Use the LEFT function in cell C5 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 (C4) as the "[num_chars]" argument.
b. Since the "#" symbol is one character past the text you want to return, you will need to adjust the "[num_chars]" argument by subtracting 1 from the reference to cell (C4).
 2.3 Use the LEFT function in cell C5 to return the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!