Modifying letters types in excel

[[email protected]]

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.

[davesexcel]

This will extract the 1st name
=LEFT('STAFF LIST'!C2,IF(ISERROR(FIND(",",'STAFF LIST'!C2,1)),LEN('STAFF LIST'!C2),FIND(",",'STAFF LIST'!C2,1)-1))

You can format the cell in B14 so there are no decimals

[[email protected]]

Sorry I did not inform you there is a validation in F1 through which the sheet is linked to the "STAFF LIST". There is also supposed to be "Dear" before the first name.

Thanks.

[davesexcel]

Give this a run, instead of index match it uses vlookup.

Please Login or Register  to view this content.

[[email protected]]

Thanks a lot.

But I tried to fix the formular to seperate grade and step and the attached is what I got.

Could you please adjust the formular to effect the changes.

I remain grateful.

[davesexcel]

Try,
=VLOOKUP(F1,'STAFF LIST'!A2:K7,11,0)
to get the 4.01, then format the cell to no decimals

The formula I gave earlier was to Extract the first name and display it in Proper Text.

Did you not already have a formula to get the 4.01 and all you had to do was format the cell to no decimals?

[[email protected]]

Thanks so much. I have entered the formular to get the grade. What then will I do to get the steps. Please note that the steps are in decimal. I reattached the schedule.

Please I'm sorry to have bothered you this much.

[davesexcel]

Here you go

[[email protected]]

Thanks Davesexcel.

You've really made me proud. I'm grateful.

[[email protected]]

Sorry I'm revisiting this.

Is there any way I can format the sheet "Offer letter" so that instead of being left aligned, the characters will be justified as it is in MS word. This will make my work decent. I will appreciate any contribution.

Thanks.

[[email protected]]

Please I'm yet to get solution on this. I will appreciation any solution.