Thread: Transfering data from a .pdf file to word and then to excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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


Reply With QuoteReply With Quote