Text to columns is cutting out data

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?

OMG that worked thank you so much! How would I ever have figured that out, lol!

Maybe do this in two steps.

First replace bracketed terms with a single character. Here's a link which has a function for using regular expressions.

http://excel.tips.net/T003303_Wildca...With_Text.html

I've modified this slightly to cope with multiple occurences

Public Function SearchNReplace1(Pattern1 As String, _
  Pattern2 As String, Replacestring As String, _
  TestString As String) As String
    Dim reg As New RegExp

    reg.IgnoreCase = True
    reg.MultiLine = False
    Do
        reg.Pattern = Pattern1
        If reg.Test(TestString) Then
            reg.Pattern = Pattern2
            TestString = reg.Replace(TestString, Replacestring)
        Else
            SearchNReplace1 = TestString
            Exit Do
        End If
    Loop
End Function

=SearchNReplace1("\[.*\]","\[.*\]","|",A1)


Then do a text to columns with the | character as a delimiter.