+ Reply to Thread
Results 1 to 2 of 2

Formula for splitting cell contents into two rows?

  1. #1
    Registered User
    Join Date
    05-28-2014
    Posts
    21

    Formula for splitting cell contents into two rows?

    So,

    I'm attempting to use information from a data dump. My problem is that some of the categories have been given multiple identifiers. For example, "Oranges" are shown as having a two designations - written in the adjacent cell as North/North West.

    In order for my lookups to work and the template to be fully automated I need a piece of formula that will allow me to split up those designations into two separate rows (directly on top/beneath each other) that show just "North" and "North West".

    I have an if function that will be able to determine when this will need to happen and when it wont, but I can't think of a formula that I can nest inside that will actually carry out the splitting - or copying and pasting - or anything equivalent.

    Is this possible?

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Formula for splitting cell contents into two rows?

    You might be able to use your data "as is". Can you post an example of what you want to do?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

+ 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. splitting contents of a column to multiple rows
    By jjame0 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-13-2013, 03:40 AM
  2. [SOLVED] Splitting cell contents based on Comma and inserting new rows below it.
    By SS113 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-22-2013, 09:09 AM
  3. [SOLVED] Splitting contents of 2 cells into rows
    By blackls1z in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 08-22-2012, 09:36 AM
  4. Splitting the contents of a cell
    By sheargraphix in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-14-2011, 07:11 AM
  5. Duplicating rows and splitting cell contents
    By levycraig in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-25-2010, 05:55 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