seperate coordinate string from multipolygon kml

What you need is text processing, something Excel does rather poorly. Since it appears your data is insensitive enough to upload here, it may be insensitive to upload to Google Drive. Which is a roundabout way of suggesting that you use Google Sheets to handle this. If your cells D2 and D3 are representative,

D4: =regexreplace(D2,">[^<].*",">")
D5: =transpose(split(regexextract(D2,"[-,. 0-9]+"),","))

D18: =regexreplace(D3,">[^<].*",">")
D19: =transpose(split(regexextract(D3,"[-,. 0-9]+"),","))

The D4 and D18 formulas extract the initial tags from D2 and D3, respectively, and the D5 and D19 formulas each produce multiple cells with individual coordinates from D2 and D3, respectively.

I don't believe you've provided an exhaustive sample of the strings you're dealing with, this is a text parsing exercise, and Excel simply isn't good at that compared to many other tools. Google Sheets is only a bit better. If you use an advanced text editor like Notepad++, it'd be better still. However, scripting languages with build in support for regular expressions would be the best tools you could use for something like this.

You could do this in VBA, but I believe there are so much better options that I won't pursue that.