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

  • Thread starter Thread starter David Bateman
  • Start date Start date
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
 
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
 
Back
Top