I have approximatly 35,000 records in a similar format to the 4 records shown below. What I need to do is put the destination code into the next cell. The destination is always between the word to and the country in brackets.
1.13 B to DA [Germany] The result should read DA
213.27 BC to S AW2 [USA] The result should read S AW2
2.16 DVB to BA SJ [Finland] The result should read BA SJ
1.1543 B to DA 1DCDS [Germany] The result should read DA 1DCDS
Can anyone help with the formula as I cannot get it to work?
Thanks
1.13 B to DA [Germany] The result should read DA
213.27 BC to S AW2 [USA] The result should read S AW2
2.16 DVB to BA SJ [Finland] The result should read BA SJ
1.1543 B to DA 1DCDS [Germany] The result should read DA 1DCDS
Can anyone help with the formula as I cannot get it to work?
Thanks