Results 1 to 4 of 4

Force IF statement to show on new line (ALT+ENTER) in cell

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-30-2012
    Location
    Leeds
    MS-Off Ver
    Excel 2013
    Posts
    177

    Force IF statement to show on new line (ALT+ENTER) in cell

    Hi all,
    SS attached, looking at sheet 1

    I have LONG string of IF statements that combine comments in my sheet. Is there a way to force each IF statement to show on a new line, as the current layout makes it very difficult to understand.

    Even better if there is a way to only force a new line if the IF is true!

    current code:
    =IF(FIND(AL$1,AL2),AL2&" - ","")&" "&IF(FIND(AM$1,AM2),AM2&" - ","")&" "&IF(FIND(AN$1,AN2),AN2&" - ","")&" "&IF(FIND(AO$1,AO2),AO2&" - ","")&" "&IF(FIND(AP$1,AP2),AP2&" - ","")&" "&IF(FIND(AQ$1,AQ2),AQ2&" - ","")&" "&IF(FIND(AR$1,AR2),AR2&" - ","")&" "&IF(FIND(AS$1,AS2),AS2&" - ","")&" "&IF(FIND(AT$1,AT2),AT2&" - ","")&" "&IF(FIND(AU$1,AU2),AU2&" - ","")&" "&IF(FIND(AV$1,AV2),AV2&" - ","")&" "&IF(FIND(AW$1,AW2),AW2&" - ","")&" "&IF(FIND(AX$1,AX2),AX2&" - ","")&" "&IF(FIND(AY$1,AY2),AY2&" - ","")&" "&IF(FIND(AZ$1,AZ2),AZ2&" - ","")&" "&IF(FIND(BA$1,BA2),BA2&" - ","")&" "&IF(FIND(BB$1,BB2),BB2&" - ","")&" "&IF(FIND(BC$1,BC2),BC2&" - ","")&" "&IF(FIND(BD$1,BD2),BD2&" - ","")&" "&IF(FIND(BE$1,BE2),BE2&" - ","")&" "&IF(FIND(BF$1,BF2),BF2&" - ","")&" "&IF(FIND(BG$1,BG2),BG2&" - ","")&" "&IF(FIND(BH$1,BH2),BH2&" - ","")&" "&IF(FIND(BI$1,BI2),BI2&" - ","")&" "&IF(FIND(BJ$1,BJ2),BJ2&" - ","")&" "&IF(FIND(BK$1,BK2),BK2&" - ","")&" "&IF(FIND(BL$1,BL2),BL2&" - ","")&" "&IF(FIND(BM$1,BM2),BM2&" - ","")&" "&IF(FIND(BN$1,BN2),BN2&" - ","")&" "&IF(FIND(BO$1,BO2),BO2&" - ","")&" "&IF(FIND(BP$1,BP2),BP2&" - ","")&" "&IF(FIND(BQ$1,BQ2),BQ2&" - ","")&" "&IF(FIND(BR$1,BR2),BR2&" - ","")&" "&IF(FIND(BS$1,BS2),BS2&" - ","")&" "&IF(FIND(BT$1,BT2),BT2&" - ","")
    Any advice appreciated! Luke
    Attached Files Attached Files

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