LinkBack URL
About LinkBacks
I am trying to cut and paste from a PDF document into excel and a grab of text when
pasted sits in three boxes instead of one. How can I manage this? Thank you.
Pasting multiple Lines of text into one cell
I am trying to cut and paste from a PDF document into excel and a grab of text when
pasted sits in three boxes instead of one. How can I manage this? Thank you.
Instead of just selecting the cell and pasting the text, click in the formula box and paste the text there.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
have you tried paste special as either text or csv?
or put your cursor in the formula box and paste then?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Thank you for your reply. Have done that and works but even after wrap text there are still gaps at the ends of the lines. They finish too short and send the text to the next line.
What is the trick to avoid that?
I think we'd need to see examples of the pdf file and the workbook after you've pasted the data.
Basically, the data you are copying has New Line and or Carriage Return characters in it. When you paste it directly into a cell, Excel uses those characters to spread the data over several cells. When you paste it into the Formula box, those characters do what they're meant to, giving you data split across lines within the cell. The fact that the data has the New Line characters in it should prompt Excel to turn on Wrap Text. The effect that you get depends how wide the column is.
The New Line and Carriage Return characters hark back to the days of dot matrix printers and line printers which, in turn, emulates a type-writer. Carriage Return takes the print head back to the start of the current line; New Line takes you to the next line.
Regards, TMS
Thanks again TMS. Very interesting about the characters in the data. Thought something like that might be the case. Have tried widening the column and yes that does get rid of it. So will keep columns narrower for entry purposes at the moment but can widen if I need to. Not a big issue but all good learning about Excel.
Just giving you a bit more background in case you know any better ways to do it - I am pasting whole paragraphs into Excel from the PDF document - have lots of columns - 6,5 and 10 in Sheets 1, 2 and 3 - so the columms get long and cant see all the text - but can of course shift around the size of the boxes to see it and also when i want to print it off adjust the size boxes and just fit enough in the print screen to see appropriately and exepct there will be a big number of printed pages. Is that the way to go?
If you want/need the paragraphs to be narrower, you can add your own new line(s) at a suitable point(s) by pressing Alt-Enter.
Other than that, you seem to have summarised the situation well.
Regards, TMS
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
Just giving you a bit more background in case you know any better ways to do it - I am pasting whole paragraphs into Excel from the PDF document - have lots of columns - 6,5 and 10 in Sheets 1, 2 and 3 - so the columms get long and cant see all the text - but can of course shift around the size of the boxes to see it and also when i want to print it off adjust the size boxes and just fit enough in the print screen to see appropriately and exepct there will be a big number of printed pages. Is that the way to go? Thanks NonieH
Apologies for the double post - looked like it was stuck and did not go through. Thanks for the info re how to mark if the problem is solved. Sorry for not clicking on the star Add Reputation - I have tried and it goes blue for a little while and then just back to black.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks