split cell accross help

[wrighty998]

please help with a formula to split my cell

input cell

DSEN 52, DTOR 3, DAMR 79, SSEN 0, STOR 2, SAMR 5, SPROD YES <tbody> </tbody>

<tbody>
</tbody>

<tbody></tbody>

output cells

52

3

79

0

2

5

yes

<tbody>
</tbody>

 

[wrighty998]

Going back to an earlier question I asked:

sorry, schdeule tool.xlsm - thisworkbook (code)

 

[Joe4]

sorry, schdeule tool.xlsm - thisworkbook (code)

Just as I thought, you put it in the wrong place. It needs to go in a Standard (General) Module.
lrobbo314 has directions in his signature on how to do that:

To add code to a workbook. Hit Alt+F11. Hit Alt+I+M to insert new module. Then paste code.

 

[wrighty998]

Just as I thought, you put it in the wrong place. It needs to go in a Standard (General) Module.
lrobbo314 has directions in his signature on how to do that:

WHAT a idiot i am, thank you so much

 

[Joe4]

You are welcome.
We are glad we could help.

 

[wrighty998]

The custom function has 2 arguments. The first on is the range where your data is. The second one is an index. The code is splitting your data into an array. The array splits up your data using the commas and spaces. DSEN 52, DTOR 3, DAMR 79, SSEN 0, STOR 2, SAMR 5, SPROD YES. So the first item in the array is DSEN 52, the second is DTOR 3, and so on. So column(A1) is just a way to get an number to increment 1,2,3,.... to reference the various elements in the array.

thank you so much for the code works great