On 10/14/2010 6:35 AM, anand warik wrote:
I copied the text from Evince Pdf viewer, when i copy, the entire
sentence is picked up as it is and pasted in one cell(*NOW* after your
suggestions, earlier not even that used to happen) but displayed in many
cells. whenever part of the sentence is on next line a long space seems
to come up.
I have found that when I copy and paste from a PDF file the text copies
exactly as it appears in the pdf. ie; if you copy
line one
line two
line three
it will paste as
line one
line two
line three
and not as
line one line two line three
even if it is one sentence.
PDF's treat all end of line's as either a paragraph break or a line
feed-carriage return. The only work around I have found is to copy the
text to a text editor that will allow you to search and replace that
paragraph break ( I use NoteTab lite) then paste that text into your cell.
--
Gene Young
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
