Hello guys,
I have large xls file wherein one cell has 100+ words...
Out of that specific cell (J1,J2,j3...) I want to extract content which is in "[ ]" square brackets. The problem is that there is sometimes one pair of brackets in the cells, but sometimes is also 3-4 pairs of brackets...
I managed to extract from first bracket pair, but for other ones, I cant do it.
Hope someone can help. If you need more information, comment please
Thanks in advance
I have large xls file wherein one cell has 100+ words...
Out of that specific cell (J1,J2,j3...) I want to extract content which is in "[ ]" square brackets. The problem is that there is sometimes one pair of brackets in the cells, but sometimes is also 3-4 pairs of brackets...
I managed to extract from first bracket pair, but for other ones, I cant do it.
Hope someone can help. If you need more information, comment please

Thanks in advance