C
Christopher Naveen
Hi
I have a cell which contains 300+ of email ID's seperated by commas, Pls
refer the example as shown below
A1
(e-mail address removed), (e-mail address removed), (e-mail address removed), (e-mail address removed), (e-mail address removed),
(e-mail address removed), (e-mail address removed), (e-mail address removed), ..........
Now i want to split the email ID's seperately as show below,
A1
(e-mail address removed),
A2
(e-mail address removed),
A3
(e-mail address removed),
A4
(e-mail address removed), 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.
I have a cell which contains 300+ of email ID's seperated by commas, Pls
refer the example as shown below
A1
(e-mail address removed), (e-mail address removed), (e-mail address removed), (e-mail address removed), (e-mail address removed),
(e-mail address removed), (e-mail address removed), (e-mail address removed), ..........
Now i want to split the email ID's seperately as show below,
A1
(e-mail address removed),
A2
(e-mail address removed),
A3
(e-mail address removed),
A4
(e-mail address removed), 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.