Formula to Get the text

[Taislin]

Hi... i have a sheet with several cells in a collumn with a text formated as this sample:

Back,TEST,"00:11:22","Soccer / Brazilian Soccer / Brazilian Paulista A1 / Fixtures 20 March / Oeste v Bragantino SP / Over/Under 3.5 Goals - Over/Under 3.5 Goals","Under 3.5 Goals","11.81","1.32","-11.81","106.31"

Then i built up formulas that extract the text i want from this cell like, for example:

Please Login or Register  to view this content.

The thing is i dont know how to extract the 11.81 value or 1.32 or 106.31 to individual cells.
I attached a sample file with the formulas i already buit to get info like Brazilian Soccer, Brazilian Paulista A1, 20 March and Under 3.5 Goals but i cant get those 3 values.
Please if someone can help i would be really appreciated.
Thank you

[mehmetcik]

Hi

I think that you will need a user definable function to do that.

The split function will split your text using any character that you choose, in your case a comma.

Please Login or Register  to view this content.

I have built this into your spreadsheet.

you can insert it anywhere format =SplitString( String or cell ref, position)

[Taislin]

@mehmetcik

Thank you for your response. Never though do the split by vba code since i allways get the text i want using MID formula. The thing is, that the text i have in cell A1 is only the first one, because the original one has a random list in collumn A (A1, A2, A3...) of these cells and i wanto to retrive each data from each of these lines. And from what i checked the macro code only splits the A1 cell, and i need it to split any active cell on A that as this kind of text. Let me add the original one so you can undestand.
Thank you