Results 1 to 2 of 2

Thread: Excel Help

  1. #1

    Excel Help

    How would I divide one cell into two cells? For example, in column A, I have:

    abcdefg blah blah blah blah
    xoxoxo blah blah dee dee dah
    ect ect

    How would I divide this into two different columns? I'm using Microsoft Office '07.

  2. #2
    She who must be obeyed Super Moderator piaqt's Avatar
    Join Date
    Apr 2002
    See office 2007 help topic id HP01216399
    Split the contents of a cell across multiple cells
    Select the cell, range, or entire column that contains the text values that you want to distribute across other cells.

    A range can be any number of rows tall, but no more than one column wide. You also need to keep enough blank columns to the right of the selected column to prevent existing data from being overwritten by the data that will be distributed.

    On the Data tab, in the Data Tools group, click Text to Columns.

    Follow the instructions in the Convert Text to Columns Wizard to specify how you want to divide the text into columns.

    For help with completing all the steps of the wizard, click Help in the Convert to Text Columns Wizard.

    Last night, I shot an elephant in my pajamas. How he got in my pajamas, I'll never know.
    love, piaqt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts