Can someone help me in providing formula for removing [] and data in it?
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 479px"><col width="349"></colgroup><tbody>
</tbody>
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
DATA | RESULTS |
ABC [2.5], JKB [23.3] | ABC, JKB |
Norway [.45] | Norway |
Smaller then1-5 days [12.5],5-12 days [34.5],13-25 days [23.3], 26-50 days [45.2] | Smaller then1-5 days, 5-12 days ,13-25 days , 26-50 days |
DGF&co (fdg) [3.4] | DGF&co (fdg) |
GEMINI PLC/THE [5.22], Leo CORP [23..0] | GEMINI PLC/THE, Leo CORP |
empty | empty |
<colgroup><col style="width: 479px"><col width="349"></colgroup><tbody>
</tbody>