There is random multi-line text (as below example in one cell)min most of the cells of column B of the excel sheet.
#A [G2]
2G 1A -11.2 2.361 G(1)
#B
00000000
00000000
#A [G2]
2G 1A -11.2 2.361 G(8a)
#B
#A [G2]
1G 1A -11.2 2.361 G(8)
#B
00000000
00000000
#A [G2]
3G 1A -11.2 2.61 G(7)
#B
#A [G2]
3G 1A -1.2 2.361 G(6)
#B
#A [G2]
1G 1A -11.2 2.1 G(8c)
#B
00000000
00000000
I need the output as below as
in column C cells: G(8), G(8c)
in column D cells: G(1), G(8a)
in column E cells: G(7), G(6)
Bookmarks