Results 1 to 11 of 11

Modifying letters types in excel

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-17-2010
    Location
    Nigeria, Owerri
    MS-Off Ver
    Excel 2007 and 2013
    Posts
    254

    Modifying letters types in excel

    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.
    Attached Files Attached Files
    Last edited by [email protected]; 07-06-2010 at 11:16 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1