+ Reply to Thread
Results 1 to 3 of 3

Seperating Data in a cell to multiple cells

  1. #1
    Registered User
    Join Date
    12-18-2007
    Posts
    2

    Seperating Data in a cell to multiple cells

    Ok, so say i have a cell with value "3012-3034"
    and i want it to put "3012" in its own cell and "3034" into another one beside it.

    Is this even possible?

    Thanks in advance,
    Gavin.

  2. #2
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    Select the column of data.
    Go to Data > Text to Columns (new window will be opened)
    Select Delimited option and press Next
    Select Others and put - in box, press Next then Finish.

  3. #3
    Registered User
    Join Date
    12-18-2007
    Posts
    2
    wow, excel never ceases to amaze me...
    Too bad you cant seem to set two different delimiters for the same data though.

    Thanks for your help and for the speedy reply starguy, much appreciated!

    Gavin

+ Reply to 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