When I import a PDF into an Excel file, sometimes, multiple lines go into 1 cell. Like this:
North
South
East
West
will go into one cell instead of 4 separate rows. I can't reveal the codes to find out how the PDF splits the lines. Right now I am exporting the info word, pasting as plain text, and then copying and pasting back into excel. Is there a better way to fix this (to have the info go into separate rows )? I know this is vague, but I can't look at the pdf to find out what causes this.
Problems with PDF files
-
- 3StarLounger
- Posts: 235
- Joined: 08 Jun 2010, 20:03
- Location: Morgantown, PA
Problems with PDF files
Cordially,
Bob Sullivan
Elverson, PA
Bob Sullivan
Elverson, PA
-
- Administrator
- Posts: 78540
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Problems with PDF files
A PDF file is basically a printout in file form. To convert this back into a Word document or Excel worksheet can be a hit-and-miss process - the converter has to guess at what the original document looked like. It's a bit like converting a stew back to its original ingredients...
Excel does not have a direct way of splitting a multi-line cell into multiple rows. It does let you split a cell into multiple columns: Data > Text to Columns, with Ctrl+J (a line break) as delimiter.
You'd then have to copy the cells in multiple columns and paste them transposed. I'm not sure that would be faster than the route via Word that you describe.
Excel does not have a direct way of splitting a multi-line cell into multiple rows. It does let you split a cell into multiple columns: Data > Text to Columns, with Ctrl+J (a line break) as delimiter.
You'd then have to copy the cells in multiple columns and paste them transposed. I'm not sure that would be faster than the route via Word that you describe.
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 235
- Joined: 08 Jun 2010, 20:03
- Location: Morgantown, PA
Re: Problems with PDF files
Thanks! Didn't know about the Ctrl+J for line break in text to columns.
Cordially,
Bob Sullivan
Elverson, PA
Bob Sullivan
Elverson, PA
-
- 5StarLounger
- Posts: 720
- Joined: 21 Aug 2011, 21:01
- Location: The beautiful hills of Western North Carolina
Re: Problems with PDF files
Bob, does the data in the PDF translate into a table in Word?BobSullivan wrote: ↑02 Dec 2022, 19:55Right now I am exporting the info word, pasting as plain text, and then copying and pasting back into excel.
Kim
"Hmm. What does this button do?" Said everyone before being ejected from a car, blown up, or deleting all the data from the mainframe.