View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default HELP ME!!! Condensing multiple cells with text and too many blank

F5SpecialBlanksOK

EditDeleteShift cells up?


Gord Dibben MS Excel MVP

On Sat, 17 May 2008 07:26:01 -0700, Jose wrote:

I have several hudred columns of text cells interspersed with blank cells.
Instead of manually deleting each blank cell, I would like to do this with a
formula, or a macro, although I am not good with macros.

I would appreciate any help I can get.

Thanks for your time.