+ Reply to Thread
Results 1 to 20 of 20

How do I copy cells and remove blank?

Hybrid View

  1. 01-30-2018, 09:38 AM #1
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,933

    Re: How do I copy cells and remove blank?

    Here is a copy of the file with the formula applied as described.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
  2. 01-30-2018, 10:21 AM #2
    Bifi85
    Bifi85 is offline
    Registered User
    Join Date
    01-10-2018
    Location
    Ger
    MS-Off Ver
    365
    Posts
    11

    Re: How do I copy cells and remove blank?

    It works thank you. What I have to do that this "easy mode" "=IF(ISTEXT(G7);G7;F6)" works?
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help with Formula: Remove trailing commas or using IF to remove results from blank cells?
    By khepra in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-23-2016, 12:22 PM
  2. [SOLVED] Cocatenate Range of Cells in a column, remove blank cells, and stack text in a cell
    By paxile2k in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-22-2014, 07:47 PM
  3. [SOLVED] Remove Blank Cells from a Range when blank cells are actually a “” result from a IF Func.
    By berne1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-26-2013, 06:26 PM
  4. Remove or hide time when copy is blank
    By debbiesh in forum Excel General
    Replies: 2
    Last Post: 03-07-2011, 02:54 PM
  5. remove blank rows and copy new range
    By twofootgiant in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2010, 09:11 AM
  6. How to remove blank cells from row
    By Spac3Monkey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-03-2009, 10:29 PM
  7. copy column of data, remove blank cells
    By inky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-22-2008, 09:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1