Excel 2008 : Split cell with 4 comma separated values into 4 separate cells

**anthrorob** · 01-11-2012, 02:06 PM

Hello,

Not enough room in the title to explain. I have numerous cells with an entry listed in a numerical array, for example: (7,3,9,8) and I would like to quickly convert them to four separate cells within one column. So, using the example above, the output would be four separate cells like this:
7
3
9
8

I have hundreds of cells to convert this way and it would be handy to have an automated way to do this. If there is no Excel function to do this, is there either a way to write the script or a place to find someone who can write the script for me (for a few coins)?

Thank you and I apologize in advance for any forum rules I may have violated (even after reading them).

Thank you!
anthrorob

**NBVC** · 01-11-2012, 02:20 PM

So if that "array" is in cell A1, try in A2:

=MID(A$1,2*(ROWS(A$1:A1)-1)+1,1)+0

copied down 4 cells.

You can copy across to extract from B1 and so on....

**dilipandey** · 01-11-2012, 02:20 PM

Hi anthrorob,

Welcome to the forum.
Though not clear how your data is arranged but it can be simply done using Text to Column feature of MS Excel where you can separate data basis comma (,) and after this you just need to replace brackets i.e., ( and ) with blank. If you get the output in horizontal form, you can convert that later to vertical form using copy - paste special - transpose option. Would like to give a try if you could upload a sample file for this. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>