Hi,

I have eight lines of text in a cell and I am not able to do any type of
copy and paste special too. Copy and paste special functions are not working
to split eight lines of text in a cell to eight separate cells.

Please help me with any formula on this.

Regards,
Igneshwara reddy.