+ Reply to Thread
Results 1 to 3 of 3

How do you split a cell that contains multiple data to the cells beside it?

Hybrid View

kjy1989 How do you split a cell that... 05-09-2013, 01:51 AM
AndyLitch Re: How do you split a cell... 05-09-2013, 01:57 AM
AndyLitch Re: How do you split a cell... 05-09-2013, 08:37 AM
  1. #1
    Forum Contributor
    Join Date
    12-03-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    107

    How do you split a cell that contains multiple data to the cells beside it?

    So i received this database that contains all the information ins the Column A, what my boss wants me to do is to separate them, for example the item description in cell A1 is :

    TS160H ATU160 125A 4P3D EXP

    This is the code for the product, each description separated by a space in the cell. So i'll have to put TS160H in column B1, ATU160 in column B2, 125A in column B3, 4P3D in column B4, and EXP in column B5.


    But the database is over 4,000 rows and it would take me all day if i manually separated all of them. Is there a macro for this?

    Thanks in advance.

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: How do you split a cell that contains multiple data to the cells beside it?

    1. Make sure the data starts in cell A1
    2. Select column A...
    3. Select "Data" on the ribbon tab.
    4. Select "Text to Columns"
    5. Select delimited on the popup and Next
    6. Check the "Space" checkbox
    7. Verify the data seperates as expected in the white data preview area
    8. Select "Finish"
    Elegant Simplicity............. Not Always

  3. #3
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: How do you split a cell that contains multiple data to the cells beside it?

    Your welcome
    Can you mark the thread as solved please?

+ 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