Formula to convert a CSV string directly to cells

[mtheriault2000]

Hello

I got a string separated by coma that is send to a cell. This string is updated every 500 ms

I know that i can convert that string by selecting it and use the convert tool on my toolbar.

My question is, Is it possible to create a formula in the targeted cell to split and convert it automatiquely as soon as the string is updated.

Ex:
- A string "1.40570,1.40580,1.40565,1.40570,1.4675" is copied to cell ("C9").
- I'm looking for a formula to be placed in cells
("B17") to contain 1.4057
("B18") to contain 1.4058
("B19") to contain 1.4065
("B20") to contain 1.4075

That could be done in VBA, but I want to know if it is possible to do it using formula in cells

Martin

 

[bosco_yip]

B17, formula copy down :

=--TRIM(MID(SUBSTITUTE(C$9,",",REPT(" ",50)),ROWS(A$1:A1)*50-49,50))

Regards

 

[mtheriault2000]

B17, formula copy down :

=--TRIM(MID(SUBSTITUTE(C$9,",",REPT(" ",50)),ROWS(A$1:A1)*50-49,50))

Regards

Thank Bosco_yip , I will try that.

I just found also
B17=STXT(DataString;1;7)
B18=STXT(DataString;9;7)
etc.

Martin