+ Reply to Thread
Results 1 to 2 of 2

have list of names and want to switch names around by putting the first initial last

  1. #1
    Registered User
    Join Date
    01-10-2014
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question have list of names and want to switch names around by putting the first initial last

    I have cells with names in them which are formatted firstinitial. lastname
    Some of the cells have multiple names in them, such as A. Minchinton, I. Kirby, J. Chan
    I would want this to look like Chan, J., Kirby, I., Minchinton, A. - all in one cell.
    The most names I have in one cell like this is 5.
    Is there a formula to make this format in the way I want?

  2. #2
    Valued Forum Contributor
    Join Date
    12-25-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    506

    Re: have list of names and want to switch names around by putting the first initial last

    If you don't mind some manual tasks, try:

    Assume your names in column A
    1. Split column A to 5 columns delimit by comma (use Text-to-Columns function in the Data menu), and you'll have A. Minchinton in A1, I. Kirby in B1 and J. Chan in C1

    2. Use this formula in F1 and copy till J1
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    3. Use this formula in K1 and you shall see Chan, J., Kirby, I., Minchinton, A.
    Formula: copy to clipboard
    Please Login or Register  to view this content.




    _______________________________________________________________________________________________________________________________
    1. Click on the * Add Reputation if you think someone helped you
    2. Mark your thread as SOLVED when question is resolved

    Alvin

+ 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] I need to compare student quiz submission names/grades against a master list of names.
    By NoxExcel in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-15-2013, 08:00 PM
  2. [SOLVED] Search a list of names and automatically return any names not already included in table
    By bishbash89 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-21-2013, 09:06 AM
  3. Finding and deleting a small list of names from a really big list of names
    By vitalstatistix in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-07-2011, 01:31 PM
  4. [SOLVED] Convert names into initial caps
    By Grd in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-16-2006, 02:50 PM
  5. [SOLVED] Putting Sheet Names on a list
    By arcq in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-09-2005, 11:06 AM

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