+ Reply to Thread
Results 1 to 3 of 3

How to merge empty with filled cells without deleting?

  1. #1
    Registered User
    Join Date
    05-17-2012
    Location
    Israel
    MS-Off Ver
    Excel 2010
    Posts
    22

    Unhappy How to merge empty with filled cells without deleting?

    Hello everyone,

    I have a table divided to 2 groups of 3 cells.
    I want to make it ONE group of 3 cells, so I have to merge the others.
    The problem is that I can't just COPY-PASTE, because empty cells from the second group would ruin my first group.

    I'm attaching an example:
    example.xlsx

    For instance, I'm worrying that D6:F6 would delete my current A6:C6.

    Is there any solution for this action?

    Thanks in Advance!

  2. #2
    Valued Forum Contributor
    Join Date
    09-15-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    436

    Re: How to merge empty with filled cells without deleting?

    Please try this file.
    Attached Files Attached Files
    Please click 'Add reputation', if my answer helped you.

  3. #3
    Registered User
    Join Date
    05-17-2012
    Location
    Israel
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: How to merge empty with filled cells without deleting?

    Thanks man.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to keep an averaging cell empty until all the input cells are filled
    By troyer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-29-2013, 11:02 AM
  2. Empty Cells needed to be filled using formula
    By ericohansen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-06-2013, 05:15 PM
  3. Merge if cells in another tab are filled?
    By ea223 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-27-2012, 06:13 PM
  4. display filled vs empty cells in a range
    By dr mint in forum Excel General
    Replies: 6
    Last Post: 08-04-2009, 10:38 PM
  5. Copy Data From Filled to Empty Cells
    By Sheikh Saadi in forum Excel General
    Replies: 0
    Last Post: 11-10-2005, 03:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1