Question: include manager employee in column H, In cells B13:B20, imported data from the rating system combines the manager's raise recommendation of High, Standard, or Low
include manager employee in column H, In cells B13:B20, imported data from the rating system combines the manager's raise recommendation of High, Standard, or Low followed by the manager's notes. In cells J3:J10, use a combination of text functions to return just the manager's raise recommendation of High, Standard, or Low. The values returned should not have extra spaces before or after the word. The names in A3:A10 are in the same order as A13:A20. Notice the text pattern is always the recommendation followed by a space. Be sure to Trim any extra spaces. unt create the named range Evaluations for the cell range A3:J10. ind to
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
