Thread: how do I shift the contents of the cells up to remove empty cells.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default how do I shift the contents of the cells up to remove empty cells.
For possibly better answers, elaborate further. Show us some sample data, and
the expected results. I'm having difficulty reconciling your subject line
with your description.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"auctioncoach" wrote:
I have empty cells scattered throughout a row .
whenever I delete the contents of a cell it leaves it empty. I would like to
consolidate the information in the row so no empty cells are apparent
Reply With QuoteReply With Quote