replace spaces with column breaks

WildAngus

New Member
Joined
Jan 10, 2007
Messages
28
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

Legend
Joined
Jun 19, 2002
Messages
63,651
Try Data > Text to Columns > tick Delimited and specify Space as the delimiter.
 

Forum statistics

Threads
1,082,548
Messages
5,366,227
Members
400,880
Latest member
dwb

Some videos you may like

This Week's Hot Topics

Top