Can someone help me in providing formula for removing [] and data in it?
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 |