+ Reply to Thread
Results 1 to 4 of 4

Trying to Separate a long list of Names into Different Columns

  1. 04-17-2020, 11:08 AM #1
    carneyce
    carneyce is offline
    Registered User
    Join Date
    04-17-2020
    Location
    Worcester, MA
    MS-Off Ver
    2016
    Posts
    3

    Smile Trying to Separate a long list of Names into Different Columns

    I have a very long list of names that i need to seperate in A1 into different columns. Names include that following different structures:

    Micky Mouse
    Micky M. Mouse
    Micky & Minny Mouse
    Micky M. & Minny Mouse
    Micky Mouse & Donald Duck
    Dr. & Mrs. Donald Duck

    The columns I have are:

    FirstName B1
    MiddleName C1
    LastName D1
    Spousefirst E1
    Spouselast F1
    Prefix G1

    I have tried figuring the code out for myself, but I am somewhat new and need guidance. I need to basically send the infomation tothe proper column in the same row. Any help is appreciated! (fyi list is 1,000+ names)
    Reply With QuoteRegister To Reply
  2. 04-17-2020, 12:27 PM #2
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Trying to Separate a long list of Names into Different Columns

    I would need to use a used defined function for that.

    This will take a while.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.
    Reply With QuoteRegister To Reply
  3. 04-17-2020, 01:11 PM #3
    carneyce
    carneyce is offline
    Registered User
    Join Date
    04-17-2020
    Location
    Worcester, MA
    MS-Off Ver
    2016
    Posts
    3

    Re: Trying to Separate a long list of Names into Different Columns

    Thank you! I know it is a big ask considering how complicated it is.
    Reply With QuoteRegister To Reply
  4. 04-28-2020, 10:43 AM #4
    carneyce
    carneyce is offline
    Registered User
    Join Date
    04-17-2020
    Location
    Worcester, MA
    MS-Off Ver
    2016
    Posts
    3

    Re: Trying to Separate a long list of Names into Different Columns

    Did you have any luck?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to separate long string of characters and several spaces into separate columns
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-31-2017, 07:37 PM
  2. Long list of names duplicated
    By maymano in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-27-2013, 04:44 PM
  3. [SOLVED] How to separate names in a long cell string
    By mondello in forum Excel General
    Replies: 5
    Last Post: 08-02-2012, 02:59 AM
  4. splitting a long column of data into separate columns
    By michaelkwc in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 05-23-2008, 11:25 PM
  5. [SOLVED] names in a long list
    By ferde in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-12-2006, 09:00 PM
  6. Counting how many different names in a long list
    By Quaisne in forum Excel General
    Replies: 7
    Last Post: 01-15-2006, 04:29 PM
  7. [SOLVED] Setting up a random list from long list of names ?
    By yorkshire exile in forum Excel General
    Replies: 4
    Last Post: 01-06-2005, 10:06 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1