Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with the formula
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with the formula
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|