+ Reply to Thread
Results 1 to 6 of 6

How to concatenate text cells but skip blank cells

Hybrid View

  1. 03-25-2014, 09:56 AM #1
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: How to concatenate text cells but skip blank cells

    This isn't elegant but for a limited amount of data it will work. I populated A1:A15 with formulae that drew data from other cells some of which were blank for testing.

    Formula: copy to clipboard 
    =SUBSTITUTE(IF(A1<>"",A1&", ")&IF(A2<>"",A2&", ")&IF(A3<>"",A3&", ")&IF(A4<>"",A4&", ")&IF(A5<>"",A5&", ")&IF(A6<>"",A6&", ")&IF(A7<>"",A7&", ")&IF(A8<>"",A8&", ")&IF(A9<>"",A9&", ")&IF(A10<>"",A10&", ")&IF(A11<>"",A11&", ")&IF(A12<>"",A12&", ")&IF(A13<>"",A13&", ")&IF(A14<>"",A14&", ")&IF(A15<>"",A15),"FALSE","")
    Last edited by newdoverman; 03-25-2014 at 09:59 AM.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W
    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] Combine multiple cells text into one cell, skip blank cells.
    By T15K in forum Excel General
    Replies: 6
    Last Post: 12-05-2014, 09:49 PM
  2. How to change empty cells to blank cells (need to use skip blanks function)
    By ChristopherH in forum Excel General
    Replies: 4
    Last Post: 03-08-2014, 02:03 PM
  3. Looking to create a macro that will skip blank cells in a column, find data cells
    By crayzwalz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-30-2013, 09:01 AM
  4. How to Group Cells/Data together? skip UP blank cells
    By KEbrahim in forum Excel General
    Replies: 2
    Last Post: 08-15-2008, 11:27 AM
  5. [SOLVED] How do I skip blank cells when copying over a range of cells?
    By tawells in forum Excel General
    Replies: 2
    Last Post: 06-08-2005, 11:05 AM

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