help with the formula

  • Thread starter Igneshwara reddy
  • Start date
I

Igneshwara reddy

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.
 
D

dhstein

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dowloading data of CSV file to excel file 2
UGhhhhh! Why is this so difficult - NO COPY "" 1
IF/AND/OR FORMULA HELP NEEDED 3
text parsing/table creation from single column data 1
Use & with two formulas 2
I can't copy and paste equations 0
cell extract 2
Excel 2010 not allowing me to paste as formula 5

Top