How to parse xml data that is stored as a text field in excel?

I am currently trying to convert an xml into excel and can accomplish this by importing the xml into excel as a data table. My problem is that the xml contains a CDATA field that does not get parsed ...