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

Please Login or Register  to view this content.

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


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