Closed Thread
Results 1 to 8 of 8

How do I split a cell into 3 different cells in excel?

  1. #1
    K8
    Guest

    How do I split a cell into 3 different cells in excel?

    I'm trying to build a spreadsheet with 3 columns and then on the second row
    one of the columns is split into 3 but I don't know how to do this!!

  2. #2
    JulieD
    Guest

    Re: How do I split a cell into 3 different cells in excel?

    Hi

    you can not split a cell in excel, you can, however, merge them ... so if
    you use 5 columns, merge three cells in the first row and play around with
    the sizing you might be able to achieve what you're after.

    A note however, merged cells can be a nightmare later on down the track with
    sorting / filtering etc.

    Cheers
    JulieD

    "K8" <K8@discussions.microsoft.com> wrote in message
    news:C838177E-AB30-4FCC-8F7A-70A49CD28B95@microsoft.com...
    > I'm trying to build a spreadsheet with 3 columns and then on the second
    > row
    > one of the columns is split into 3 but I don't know how to do this!!




  3. #3
    K8
    Guest

    Re: How do I split a cell into 3 different cells in excel?

    thanks Julie, K8

    "JulieD" wrote:

    > Hi
    >
    > you can not split a cell in excel, you can, however, merge them ... so if
    > you use 5 columns, merge three cells in the first row and play around with
    > the sizing you might be able to achieve what you're after.
    >
    > A note however, merged cells can be a nightmare later on down the track with
    > sorting / filtering etc.
    >
    > Cheers
    > JulieD
    >
    > "K8" <K8@discussions.microsoft.com> wrote in message
    > news:C838177E-AB30-4FCC-8F7A-70A49CD28B95@microsoft.com...
    > > I'm trying to build a spreadsheet with 3 columns and then on the second
    > > row
    > > one of the columns is split into 3 but I don't know how to do this!!

    >
    >
    >


  4. #4
    Guest

    How do I split a cell into 3 different cells in excel?

    not sure what you have in mind but try text to columns on
    data menu.

    >-----Original Message-----
    >I'm trying to build a spreadsheet with 3 columns and then

    on the second row
    >one of the columns is split into 3 but I don't know how

    to do this!!
    >.
    >


  5. #5
    iloveexcellllll
    Guest

    RE: How do I split a cell into 3 different cells in excel?

    I generally do not merge cells in a worksheet/workbook because once you start
    merging, you won't be able to sort without the possibility of loosing
    information.
    I like to use a separate column for all of my headers and work down and
    across for each new subset of data.

    example:
    Jan Sales
    Mark Susan Joan

    "K8" wrote:

    > I'm trying to build a spreadsheet with 3 columns and then on the second row
    > one of the columns is split into 3 but I don't know how to do this!!


  6. #6
    CCW
    Guest

    RE: How do I split a cell into 3 different cells in excel?

    I have found this problem long after it has been posted but I do a lot of
    spread sheets and "HAD" the same problem. The previous comments were all
    true as far as I know, but the trick to achieve what you are trying to do is
    to:


    => Type the Heading into the 1st of the Three Cells
    => Select All 3 Cells
    => Format
    => Alignment
    => Horizontal
    => Scroll Down to Center Across Selection & Select

    This allows you to Sort the Data As Well.

    Note - Do Not Put any information into the the cells to the right of the
    first cell where the heading is.


    "K8" wrote:

    > I'm trying to build a spreadsheet with 3 columns and then on the second row
    > one of the columns is split into 3 but I don't know how to do this!!


  7. #7
    Registered User
    Join Date
    05-30-2007
    Posts
    21

    Re: How do I split a cell into 3 different cells in excel?

    => Type the Heading into the 1st of the Three Cells
    => Select All 3 Cells
    => Format
    => Alignment
    => Horizontal
    => Scroll Down to Center Across Selection & Select

    I cannot find the Alignment and Horizontal and scroll down in Excel 97.

    How do I find.

    Thks
    Charlie

  8. #8
    Forum Moderator DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Suffolk, UK
    MS-Off Ver
    2002, 2007 & 2010
    Posts
    21,520

    Re: How do I split a cell into 3 different cells in excel?

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

Closed Thread

Thread Information

Users Browsing this Thread

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

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