Data range

[senjuti.sarkar]

Dear Friends,

My Excel Sheet has Datas separated by "," in a single cell,i.e, a,b,c,d,e
i need them separately in continuous cells veritically like..

a
b
c
d
e

Can any body help me.

Regards
Senjuti

[ramananhrm]

Please try this function

Paste this function in A2 & copy down.
=MID($A$1,(ROWS($A$2:A2)*2)-1,1)

[senjuti.sarkar]

Dear Friend,

I understood the concept, actualy here my datas are email ids...separated by "," like abc@abc.com, 123@abc.com, so on...

I need to separate each email id.

Regards
Senjuti

[hudibyk]

I can't agree with ramananhrm.
senjuti.sarkar, what date format do you have in this cell?
Show example

[hudibyk]

The best way is use Text to Columns Tool, and then simply function TRANSPOSE
But remambee, TRANSPOSE is an Array Formula

[senjuti.sarkar]

WONDERFULLY DONE...

Thanks a lot.