Hello friendly excel people ![Slightly smiling face :slight_smile: 🙂](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
I've been scratching my head all day with this issue and it's really getting to me. I have a PDF doc containing a list of; suburbs/cities along with their postal code and state, organised in 7 columns across 35 pages on an A4 page.
What I'm trying to do, is to copy/import all this data into an excel worksheet, with each PDF line copied into a separate excel row.
This is an example of how I'd love the data to look like in excel. I've also put a link pdf image link of what the pdf looks like but I can provide the pdf file as a link too
I've tried copying and pasting, using the excel text import wizard, and converting the file in acrobat and online but every time I always end up with multiple (30-100) line entries in the same excel cell.
The answer's probably something really simple but for the life of me, I can't figure out how to do it.
If anyone of the wonderful excel experts here has any ideas or solutions, it'd be super appreciated.![Smiling face with smiling eyes :blush: 😊](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f60a.png)
![Smiling face with smiling eyes :blush: 😊](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f60a.png)
![Slightly smiling face :slight_smile: 🙂](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
I've been scratching my head all day with this issue and it's really getting to me. I have a PDF doc containing a list of; suburbs/cities along with their postal code and state, organised in 7 columns across 35 pages on an A4 page.
What I'm trying to do, is to copy/import all this data into an excel worksheet, with each PDF line copied into a separate excel row.
This is an example of how I'd love the data to look like in excel. I've also put a link pdf image link of what the pdf looks like but I can provide the pdf file as a link too
ARRINO WA 6519 |
ARROWSMITH WA 6525 |
ARROWSMITH EAST WA 6519 |
ARTARMON NSW 1570 |
ARTARMON NSW 2064 |
ARTHUR RIVER WA 6315 |
ARTHUR RIVER TAS 7330 |
ARTHURS CREEK VIC 3099 |
ARTHURS LAKE TAS 7030 |
ARTHURS SEAT VIC 3936 |
ARTHURTON SA 5572 |
I've tried copying and pasting, using the excel text import wizard, and converting the file in acrobat and online but every time I always end up with multiple (30-100) line entries in the same excel cell.
The answer's probably something really simple but for the life of me, I can't figure out how to do it.
If anyone of the wonderful excel experts here has any ideas or solutions, it'd be super appreciated.
![Smiling face with smiling eyes :blush: 😊](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f60a.png)
![Smiling face with smiling eyes :blush: 😊](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f60a.png)