+ Reply to Thread
Results 1 to 3 of 3

Formatting names by seperating last names from initials by a comma

  1. #1
    Forum Contributor
    Join Date
    10-06-2013
    Location
    Riyadh, Saudi Arabia
    MS-Off Ver
    Excel 2010
    Posts
    208

    Formatting names by seperating last names from initials by a comma

    Dear Friends,

    I need a formula that can produce the desired format of a large number of names that separate the initials appear at the end of the name by inserting a comma after the last names.

    Please see the attached sample. Also, please note that many last names includes spaces and some of the last names consist of two words as well.

    Basically, a formula that start on the right of the cell, find the first space and insert a comma just before the first space. I could not figure it out myself.


    Many thanks in advance, Taisir
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Formatting names by seperating last names from initials by a comma

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by protonLeah; 11-28-2014 at 02:05 AM.
    Ben Van Johnson

  3. #3
    Forum Contributor
    Join Date
    10-06-2013
    Location
    Riyadh, Saudi Arabia
    MS-Off Ver
    Excel 2010
    Posts
    208

    Re: Formatting names by seperating last names from initials by a comma

    Dear ProtonLeah

    Great. Just tried it with 13000 names plus and worked great. All the best.
    will mark this thread SOLVED

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula required for initials of names and combining initials with other text
    By iDarkAngel in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-07-2012, 11:22 AM
  2. Finding Range of People names using Initials
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2012, 06:47 PM
  3. Seperating First and Last Names
    By WilsonLA in forum Excel General
    Replies: 4
    Last Post: 04-12-2006, 12:35 PM
  4. [SOLVED] how do i convert names to initials in excel
    By dave glynn in forum Excel General
    Replies: 2
    Last Post: 09-26-2005, 12:05 PM
  5. Replies: 1
    Last Post: 05-09-2005, 07:44 PM

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