How do you propose to separate data with the delimiter of []? I am trying text to columns but the way it is formatted will only bring the first part of the data over, and nothing else. Example of data in one column:

"Abdominal abscess [244817]
MRSA infection [339874]
Quadriplegia following spinal cord injury [519546]"


That is all in one cell. I am wanting to separate into multiple columns, the above into 3 columns for instance. Thoughts?