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