Results 1 to 7 of 7

Need VBA to split up Cells where names are arranged FirstNm LastNmFirstNm LastNmFirstNm

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-19-2013
    Location
    Las Vegas, NV
    MS-Off Ver
    Office 365 2016
    Posts
    214

    Need VBA to split up Cells where names are arranged FirstNm LastNmFirstNm LastNmFirstNm

    I thought I had posted this before, but it isn't appearing in the forum list-I apologize if it duplicated due to some kind of time delay or w/e.

    Please see the attached sheet for data examples.

    I have three columns in which names are listed "FirstNm LastNmFirstNm LastNmFirstNm LastNm" that I am having an issue splitting up. There can be anywhere from one to four names per cell that would need splitting.

    Let me know if I can answer any additional questions.

    Thanks
    Kondukt
    Attached Files Attached Files
    Last edited by Miskondukt; 06-03-2015 at 01:57 PM. Reason: Resolved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Filling cells vertically with data from cells arranged horizontally
    By Sbselby in forum Excel General
    Replies: 9
    Last Post: 01-21-2014, 06:11 PM
  2. [SOLVED] Split contents of cell into single names then search for names on different sheet.
    By RichTea88 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 12-18-2013, 10:53 AM
  3. Replies: 4
    Last Post: 01-17-2013, 03:54 PM
  4. Split names into two cells
    By Terence Prideaux in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-07-2012, 11:39 PM
  5. Replies: 5
    Last Post: 12-03-2009, 05:57 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