Results 1 to 21 of 21

Excel Split Single Cell Array into Multiple Cells

Threaded View

devinpitcher Excel Split Single Cell Array... 06-08-2011, 11:09 AM
Richard Buttrey Re: Excel Split Single Cell... 06-08-2011, 11:18 AM
StephenR Re: Excel Split Single Cell... 06-08-2011, 11:18 AM
devinpitcher Re: Excel Split Single Cell... 06-08-2011, 11:23 AM
devinpitcher Re: Excel Split Single Cell... 06-08-2011, 11:26 AM
StephenR Re: Excel Split Single Cell... 06-08-2011, 11:27 AM
devinpitcher Re: Excel Split Single Cell... 06-08-2011, 11:31 AM
devinpitcher Re: Excel Split Single Cell... 06-08-2011, 11:36 AM
StephenR Re: Excel Split Single Cell... 06-08-2011, 11:46 AM
devinpitcher Re: Excel Split Single Cell... 06-08-2011, 11:50 AM
Richard Buttrey Re: Excel Split Single Cell... 06-08-2011, 12:08 PM
devinpitcher Re: Excel Split Single Cell... 06-08-2011, 12:13 PM
Richard Buttrey Re: Excel Split Single Cell... 06-08-2011, 12:36 PM
devinpitcher Re: Excel Split Single Cell... 06-08-2011, 12:42 PM
Richard Buttrey Re: Excel Split Single Cell... 06-08-2011, 12:47 PM
devinpitcher Re: Excel Split Single Cell... 06-08-2011, 12:55 PM
devinpitcher Re: Excel Split Single Cell... 06-09-2011, 08:24 AM
devinpitcher Re: Excel Split Single Cell... 06-08-2011, 12:51 PM
raju7788@gmail.com Re: Excel Split Single Cell... 12-07-2012, 06:27 AM
arlu1201 Re: Excel Split Single Cell... 12-07-2012, 06:33 AM
Marcol Re: Excel Split Single Cell... 12-07-2012, 07:13 AM
  1. #1
    Registered User
    Join Date
    06-08-2011
    Location
    Michigan
    MS-Off Ver
    Excel 2003
    Posts
    11

    Excel Split Single Cell Array into Multiple Cells

    An application I use exports strings of data in an array in one cell, like so:

    "data1"= value1; "data2"= value2; "data3"= value3; "data4"= value4; "data5"= value5;

    I'd like an equation or macro or something that could split it like this:

    ------------------------------------------------------
    |   |  data1  |  data2 |  data3  |  data4  |  data5  |
    ------------------------------------------------------
    | 1 |  value1 | value2 |  value3 |  value4 |  value5 |
    ------------------------------------------------------
    | 2 |  value1 | value2 |  value3 |  value4 |  value5 |
    ------------------------------------------------------
    | 3 |  value1 | value2 |  value3 |  value4 |  value5 |
    ------------------------------------------------------
    .....
    Is this possible?

    Excel 2003 on Windows XP
    Last edited by devinpitcher; 06-08-2011 at 11:17 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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