And, just for further reference, text to columns is meant to separate the
values across a row, not down a column.
Unfortunately, there is no text to rows function that I'm aware of...

"Sean Timmons" wrote:

Highligh the cells, copy
go to the first column of the next row, paste special checkmark "transpose"

"Jen711" wrote:

I've pasted a bunch of names into a spreadsheet and done the text to columns
wizard to seperate them into different cells. Now the problem is that they
are in cells in a single row instead of stacked on top of each other. Can
someone help me??