replace spaces with column breaks

[WildAngus]

Is there an easy way or changing a sentence of text to have each word moved to separate columns?
i.e. replace all the spaces with column breaks.

I can do it the long way to look for a space, then use left and right with parameters to manually do it, but I'm sure there's a one off command or simple macro for this.

Any help would be appreciated.

Thanks

 

[VoG]

Try Data > Text to Columns > tick Delimited and specify Space as the delimiter.

 

[WildAngus]

doh...

That's so simple.

Thank you.