You could use the "MID" formula to split up the text. Example if the text is
in A1, you could have the formula MID(A1,1,20)
the next one could be MID(A1,21,20), etc. I'm not sure if that's what
you're asking.

"Igneshwara reddy" wrote:

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.