+ Reply to Thread
Results 1 to 4 of 4

Splitting one cell within one column into rows?

  1. #1
    Registered User
    Join Date
    08-10-2015
    Location
    Chicago, IL, USA
    MS-Off Ver
    2013
    Posts
    33

    Splitting one cell within one column into rows?

    Is it possible to split a single cell within a single column into rows within that cell only? (I can hope, can't I? )

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Splitting one cell within one column into rows?

    No, it's not possible
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,298

    Re: Splitting one cell within one column into rows?

    You can use <ALT><ENTER> and use 'wrap text' to get two words one below the other in one cell
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  4. #4
    Registered User
    Join Date
    08-10-2015
    Location
    Chicago, IL, USA
    MS-Off Ver
    2013
    Posts
    33

    Re: Splitting one cell within one column into rows?

    Thanks! But I know how to get multiple items in one cell, separated by comas or line breaks. The problem with that is that I cannot sort on that column by choosing only some of the items in the cell. That's why I decided to have the insert row function expand the range (covering one record in the database) at the same time. That way I can sort by items in that column.

+ 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] Splitting Cell in multiple rows
    By JonathanReard in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-04-2014, 11:04 AM
  2. 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
  3. Splitting a cell into different rows
    By ic3cold in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-11-2013, 08:00 PM
  4. [SOLVED] Splitting multi-line cells into rows and moving the values into another column
    By Gav74 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-04-2013, 09:59 AM
  5. Splitting a cell into multiple rows.
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2013, 05:08 PM
  6. [SOLVED] Splitting column based on specific rows
    By opheim in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-03-2012, 03:05 PM
  7. Replies: 1
    Last Post: 03-11-2006, 07:50 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