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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Transfering data from a .pdf file to word and then to excel (https://www.excelbanter.com/excel-worksheet-functions/256874-transfering-data-pdf-file-word-then-excel.html)

David Bateman

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

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

Gord Dibben

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

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

FormatCellsAlignment.

Uncheck "merge cells" and OK

F5SpecialBlanksOK

EditDeleteShift Up or whatever.

Gord Dibben MS Excel MVP

On Fri, 19 Feb 2010 13:47:34 -0800, "David Bateman"
wrote:

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

All times are GMT +1. The time now is 12:11 AM.