Text to Row by Delimiter

I want to import a text file into excel. Instead of divide the text into columns by delimiter, I want to divide the text into rows by delimiter. Can anyone tell me how to do this? Thanks.

Possibly divide it by column, then select the data and do edit => copy, then
edit => Paste Special => transpose

and delete the residual initial data.

or write code to parse it and place it yourself.

--
Regards,
Tom Ogilvy

"betty77" <[email protected]> wrote in
message news:[email protected]...
>
> I want to import a text file into excel. Instead of divide the text into
> columns by delimiter, I want to divide the text into rows by delimiter.
> Can anyone tell me how to do this? Thanks.
>
>
> --
> betty77
> ------------------------------------------------------------------------
> betty77's Profile:
> http://www.excelforum.com/member.php...o&userid=37092
> View this thread: http://www.excelforum.com/showthread...hreadid=568551
>