Web Query - row is too long

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I am running a web query to get back XML data from a soap service web
view ( WebLogic to be precise ) However the row with all the data is
thousands of characters long. This results in a blank line showing.
Is there any way to get this data and the split it up before trying to
write it to excel?
Or does anyone know of any ways to connect to a URL and parse the data
in a fairly simplistic way?

Thanks
Tom

.