+ Reply to Thread
Results 1 to 2 of 2

Concatenate - Skip Blanks

  1. #1
    Registered User
    Join Date
    04-05-2007
    Posts
    1

    Concatenate - Skip Blanks

    Iím trying to concatenate multiple stings of text (7or so) from various cells that are linked to another workbook using Char(10), so I can force line breaks between each cell.

    However, if one of the cells is blank it leaves a huge space between the previous cell and the proceeding cell. Is there anyway to avoid this / skip blanks?

    I was thinking of using an If Statement, but that would require to many layers of logic. Any thoughts? I was using the formula below, but now I have to string more cells.

    =IF(AL!C619="",LA!C619&CHAR(10)&MS!C619&CHAR(10),IF(LA!C619="",AL!C619&CHAR(10)&MS!C619&CHAR(10),IF(AND(AL!C619="",LA!C619=""),MS!C619,AL!C619&CHAR(10)&LA!C619&CHAR(10)&MS!C619&CHAR(10))))


    Thank you in advance for your help!

  2. #2
    Forum Guru mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,207
    Please Login or Register  to view this content.
    apply that formula to your result. It sounds like your problem is when one of the input strings is empty, resulting in a double tab. This turns all those double tabs into a single.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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