There's no such thing as Text to Rows in Excel.

After you've done the Text to Columns, you can transpose them into rows
(copy, Paste SpecialTranspose)

Regards,
Fred.

"Mukesh" wrote in message
...

Ok I figured out Text to Column,
how do I get Text to Rows instead of column?


"Mukesh" wrote:

Hi Fred,

Yes, they are sepearted by a comma, how do I use Text to Columns?

Thanks.
Mukesh


"Fred Smith" wrote:

If they are separated by a common character such as a comma or a
semi-colon,
you can use Text to Columns. Hopefully you don't have more addresses
than
columns your version of Excel will support.

Regards,
Fred.

"Mukesh" wrote in message
...
I have many email addresses in one cell, how do I seperate them to
individual cells? Please help.

Thanks.
Mukesh