Results 1 to 17 of 17

Formula required for initials of names and combining initials with other text

Threaded View

  1. #1
    Registered User
    Join Date
    07-07-2012
    Location
    India, Pune
    MS-Off Ver
    Excel 2007
    Posts
    5

    Question Formula required for initials of names and combining initials with other text

    Hi Guys,

    I need some help here for making formulas

    1) I want formula For initials Of a name :

    Ilyas Abdul Rauf Shaikh = It should be like this - I A R S (with spaces)

    Ilyas Rauf Shaikh = I R S

    Ilyas R Shaikh = I R S

    Ilyas Shaikh = I S

    Ilyas S = I S

    I Shaikh = I S

    (i want a formula for all above cases)

    2) Second one

    Ilyas Shaikh
    Code - 3FF21GT4123F1WQE

    result should be like this First letter of Ilyas then Code and then last letter of shaikh

    I3FF21GT4123F1WQEH (without Spaces )

    Thanks in advance for help!
    Last edited by iDarkAngel; 07-07-2012 at 03:49 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