Results 1 to 9 of 9

Concatenate If Blank - remove blank line if first cell is blank

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-16-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    278

    Concatenate If Blank - remove blank line if first cell is blank

    Hi,
    This is working very well, however, if my first cell (K22) is blank, my first line is blank. Is there anyway to eliminate the first line being blank?
    (There is a return between each item.)

    =IF(LEN($K$22)=0,"", & " • " &$K$22) & IF(LEN($K$23)=0,"", "
    " & " • "&$K$23) & IF(LEN($K$24)=0,"", " Alt-Enter line return here
    " & " • "&$K$24)& IF(LEN($K$25)=0,"", " Alt-Enter line return here
    " & " • "&$K$25)& IF(LEN($K$26)=0,"", " Alt-Enter line return here
    " & " • "&$K$26)& IF(LEN($M$22)=0,"", " Alt-Enter line return here
    " & " • "&$M$22)& IF(LEN($M$23)=0,"", " Alt-Enter line return here
    " & " • "&$M$23)& IF(LEN($M$24)=0,"", " Alt-Enter line return here
    " & " • "& $M$24)

    EDIT: wrap text is on in the cell so that each is on its own line. Turning wrap text off eliminates the first blank line, but then it also eliminates each one being on its own line, which I need.

    Thank you.
    Last edited by ker9; 05-27-2014 at 02:18 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Remove CHAR(10) blank from CONCATENATE formula
    By OLLY-7 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 08-06-2023, 01:44 AM
  2. [SOLVED] Remove blank rows that aren't really blank (contain unused formulas)
    By painterartist in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-02-2014, 02:01 PM
  3. Replies: 3
    Last Post: 01-23-2014, 12:19 PM
  4. How to remove blank rows, then insert blank row conditionally, PLUS error proof
    By GTS115 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-05-2009, 11:39 AM
  5. [SOLVED] COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C.
    By QUEST41067 in forum Excel General
    Replies: 1
    Last Post: 01-15-2005, 06: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1