+ Reply to Thread
Results 1 to 5 of 5

Find all initials in Full Name...?

  1. #1
    Registered User
    Join Date
    03-11-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    6

    Exclamation Find all initials in Full Name...?

    i want an easy formula that can change name like this..

    Ragavendra - R
    Abdul Hasaad - A H
    Mohamad Nasrin Sharma - M N S
    Abdul Hamed Ibrahim Kaboor - A H I K


    Please make very easy formula to do this excel operation...


    Thanks in advance...
    Last edited by question.maker; 03-11-2013 at 04:00 PM.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Find all initials in Full Name...?

    If your text is in A1, then in A2 type
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Find all initials in Full Name...?

    Oops i just realised that though mine works for the 1st one, it doesnt for the 2nd example. Will work it out or someone with a better solution will come forth.

  4. #4
    Valued Forum Contributor Harribone's Avatar
    Join Date
    02-24-2013
    Location
    Midlands, UK
    MS-Off Ver
    Excel 2019/365
    Posts
    570

    Re: Find all initials in Full Name...?

    Found this myslef not so long ago, only works for first three initials though. Still learning text manipulation so not sure how to modify this yet untill I fully understand how it all works.

    Please Login or Register  to view this content.
    EDIT: Beaten to it! Ignore this post
    Say thanks, click *

  5. #5
    Valued Forum Contributor Harribone's Avatar
    Join Date
    02-24-2013
    Location
    Midlands, UK
    MS-Off Ver
    Excel 2019/365
    Posts
    570

    Re: Find all initials in Full Name...?

    Please Login or Register  to view this content.
    Extremely messy I know but this will work out up to 4 initials. It finds modifies the text by removing the left most name each time hence the length of the formula.

    EDIT: Wrap this in UPPER to ensure result is in capitals (if you need this to be the case):

    =UPPER("above formula")
    Last edited by Harribone; 03-11-2013 at 04:14 PM.

+ Reply to Thread

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