+ Reply to Thread
Results 1 to 2 of 2

Split cell and copy row down

  1. #1
    Registered User
    Join Date
    09-19-2018
    Location
    Scotland
    MS-Off Ver
    2010
    Posts
    13

    Split cell and copy row down

    I need to split cells in column E, like the following.

    Mr & Mrs Smith

    to become

    Mr Smith
    Mrs Smith

    In two separate lines, while keeping, and copying the rest of the row into the new line as well. The issue comes from the fact that the same must happen for every iteration of "Mr & Mrs", ie, "Mr and Mrs Smith", "Mr Smith, Mrs Smith" and so on.
    There are also a few times where the cell contains "Mr Smith Mrs Smith". To be even more demanding, this also needs to include the same variances of Mr & Mr, Mrs & Mrs, and so on and so forth.

    I realise that this is potentially a very compicated, extensive and possibly tedious task, but I have almost no experience with VBA, and can't find anything online indicating where to start.

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Split cell and copy row down

    Hello
    It is better in this case to upload sample workbook with all possible instances so as to make it easier for other members
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

+ 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] Split a string in a cell and copy splitted characters to adjacent cells
    By buhnen in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-17-2017, 02:01 PM
  2. Split cell contents and copy adjoing cell next to each resulting row.
    By vanman100 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2017, 02:04 PM
  3. [SOLVED] split cell contents into rows, and copy adjacent cells down
    By FDibbins in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-15-2016, 12:02 AM
  4. [SOLVED] Copy rows and populate with split cell values
    By Niclal in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 02-07-2014, 04:06 PM
  5. Split content from comma separated variables in a cell and copy information
    By Snajder in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-06-2012, 08:12 AM
  6. Replies: 3
    Last Post: 11-28-2011, 03:08 PM
  7. I want to split containt of a cell and copy in seprate cells
    By Sima in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-09-2005, 03:06 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1