Report Import into One Column

[Justijb]

Hello,

In the past, I've gotten a lot of feedback and I'm hoping I have the same luck. I have a report that imports into a single column that I need broken down into multiple columns. What is the code to move the data within column a, separated only by space into the next column. E.g. "XXXX XXX XXX XX XXXX XXXX XXXXXX XXX XX XXXX Vendor" after each space, it would have its own column.

Thanks so much.