Hi

I have a cell which contains 300+ of email ID's seperated by commas, Pls
refer the example as shown below

A1
, , , , ,
, , , ..........

Now i want to split the email ID's seperately as show below,

A1
,
A2
,
A3
,
A4
, like this. Can anyone help me how to do this in excel.

Also I want to know the cell contains 300+ email ID's which cannot be
spilted in the cols as excel permits max of 256 cells in cols wher i have
300+ email ID's. if i want to split the email ID's in row how can i do that?

Eagerly Waiting for ur reply.

Thanks in Advance!!!!!

-Christ.