I have an excel spreadsheet with XML in a single column. I know that you can import XML data into Excel; but only imports the entire file. However, I need to do this on a cell by cell basis.
With VBA you could probably do it, but is there a stock way of doing this in Excel?
To be clear, I haven't written any VBA code to do this, but I can manage that myself. My question is whether or not this is existing functionality like "Text to Columns". So far I've attempted Googling but only found examples of importing entire XML files.