Transfering data from a .pdf file to word and then to excel

D

David Bateman

Could someone provide a macro that would unmerge and of the cell in excel
and then delete all of the blank cells. Thank you in advance!

Best,

David
 
G

Gord Dibben

With macro recorder turned on, CTRL + A to select all cells.

Format>Cells>Alignment.

Uncheck "merge cells" and OK

F5>Special>Blanks>OK

Edit>Delete>Shift Up or whatever.


Gord Dibben MS Excel MVP
 

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

Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Cell data entering slow! 0
Merging from an Excel file with graphics 1
Embed the same Excel multiple times 0
Excel to Word to PDF workflow 1
Linking data in MS Word into Excel 5
Excel does not accept text format! 0
Word VBA - Delete text from bulleted paragraphs 1

Top