I have a value in one cell that looks like this
Lets say it's in the
how I can get the inner
8 (the second comma separated value) from this cell into the cell B1 ?
=SPLIT(A1, ","), but this splits the values and writes them to multiple cells.
Any ideas ?