+ Reply to Thread
Results 1 to 12 of 12

Split a single cell into 2 or more cells

  1. #1
    Registered User
    Join Date
    04-24-2012
    Location
    Eastern Cape
    MS-Off Ver
    Excel 2003
    Posts
    5

    Split a single cell into 2 or more cells

    Good day,

    Can anyone help me with the following:

    I would like to know if you can split 1 single cell into multiple cells in 1 column?

    Thank you,

  2. #2
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Split a single cell into 2 or more cells

    Yes, you can almost certainly do it, but without an example of what you're trying to do or (better still) a sample workbook it's very hard to advise you exactly what to do.
    Last edited by Andrew-R; 04-24-2012 at 10:31 AM. Reason: 'Without' without an out

  3. #3
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Split a single cell into 2 or more cells

    Ηι and welcome to the forum

    Yes you can.

    Give as an example.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  4. #4
    Registered User
    Join Date
    04-24-2012
    Location
    Eastern Cape
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Split a single cell into 2 or more cells

    untitled.JPG

    Thanks,

    I did give an example, I hope you can see what I inserted

    Thanks

  5. #5
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Split a single cell into 2 or more cells

    hello
    maybe you can try ----text-to-column
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  6. #6
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Split a single cell into 2 or more cells

    Or...

    In C9, Put this formula.

    =LEFT(B9;FIND(":";B9)-1)


    In D9, this.

    =TRIM(MID(B9;SEARCH(":";B9)+LEN(":");255))


    Change all the semi-colons in my formula, with comma, if you have to do it.

    Hope that helps you.


    Edit: I just noticed, that you need also this sign( with your first word.

    So in my first formula, add this. &":"

    =LEFT(B9;FIND(":";B9)-1)&":"
    Last edited by Fotis1991; 04-25-2012 at 03:07 AM. Reason: Edit:

  7. #7
    Registered User
    Join Date
    04-24-2012
    Location
    Eastern Cape
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Split a single cell into 2 or more cells

    Thanks,

    Still not working correctly, I must be doing something wrong. It keeps telling me Value or error.

    Is there some toolbar I can just open with a split function? haha

    Thank you anyway!

  8. #8
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Split a single cell into 2 or more cells

    Hi

    Take a look to the sample.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    04-24-2012
    Location
    Eastern Cape
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Split a single cell into 2 or more cells

    Thanks!

    I wanted to know how you can do that as well, but....

    I want to know if you can split a cell in Column B into 2 cells but still remain column B? I don't want to information in two columns, I want to put it in 1 column but in 2 cells in that column.

    Am I just a bit difficult now? haha

    Thank you

  10. #10
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Split a single cell into 2 or more cells

    ..Do copy & paste, cell C9 & D9, in any cell in Column B, you want(One by One)...

  11. #11
    Registered User
    Join Date
    04-24-2012
    Location
    Eastern Cape
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Split a single cell into 2 or more cells

    Hi,

    Not working. But I will just putting it in by hand.

    Thanks

  12. #12
    Registered User
    Join Date
    02-22-2013
    Location
    Aruba
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Split a single cell into 2 or more cells

    Other than what OTIS 1991 used, wich does not work on all versions of Excel, Excel does not provide this function as far as I know.
    On the other hand, Corel Quatro does have this function.
    Not saying to change from Excel to Quatro, but the only easy way to do it is to merge the 2 columns as far down as you need and unmerge only those cells you need to split.
    That is the easiest way and further more, losing one column does not make you lose any space.
    Limitations in rows and columns excel 2010: 1,048,576 rows by 16,384 columns
    Limitations in rows and columns excel 2003 & 2007: 65,536 rows by 256 columns

+ 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