Good day all.
Please I have attached a file named salary review letters.
The sheet "STAFF LIST" contains list of staff with their salary details. Sheet "SALARY REVIEW" contains their salary review letter template which has formulae linked to "STAFF LIST". In the "SALARY REVIEW", I want a formular that will remove other names in cell A8 and return only the first name such that the salutation will look like thisfor example, "Dear Alaukwu" instead of "Dear Alaukwu Chichebem". Secondly, I also want a formular that will separate the decimal values in cell B14 and place them in B14. This will change the structure of the letter to:
Your job grade remains 4
Step 1
instead of the current format.
I count on your usual assistance.
Bookmarks