J
Jase
I have formatted a cell (cell A) to link to other cells (other cells) and put
each other cells info on a seperate line in my linked cell (cell A). However
if the information in the (other cells) are blank it still puts in empty line
in my linked cell (cell A).
Is their a way to not put in a blank row into my linked cell (cell A) if the
info its reading is blank?
heres the formatting:
IF(ISBLANK(G132),"",G132&CHAR(10))
&" {"&IF(ISBLANK(G133),"",G133&CHAR(10))
&" "&IF(ISBLANK(G134),"",G134&CHAR(10))
&" "&IF(ISBLANK(G135),"",G135&CHAR(10))
&" "&IF(ISBLANK(G136),"",G136&CHAR(10))
&" "&IF(ISBLANK(G137),"",G137&CHAR(10))
&" "&IF(ISBLANK(G138),"",G138&CHAR(10))
&" "&IF(ISBLANK(G139),"",G139&CHAR(10))
&" "&IF(ISBLANK(G140),"",G140&CHAR(10))
&" "&IF(ISBLANK(G141),"",G141&CHAR(10))
&" "&IF(ISBLANK(G142),"",G142&CHAR(10))
&" "&IF(ISBLANK(G144),"",G144&CHAR(10))
&" "&IF(ISBLANK(G146),"",G146&CHAR(10))
&" "&IF(ISBLANK(G159),"",G159&CHAR(10))
&"} "&IF(ISBLANK(G160),"",G160))
each other cells info on a seperate line in my linked cell (cell A). However
if the information in the (other cells) are blank it still puts in empty line
in my linked cell (cell A).
Is their a way to not put in a blank row into my linked cell (cell A) if the
info its reading is blank?
heres the formatting:
IF(ISBLANK(G132),"",G132&CHAR(10))
&" {"&IF(ISBLANK(G133),"",G133&CHAR(10))
&" "&IF(ISBLANK(G134),"",G134&CHAR(10))
&" "&IF(ISBLANK(G135),"",G135&CHAR(10))
&" "&IF(ISBLANK(G136),"",G136&CHAR(10))
&" "&IF(ISBLANK(G137),"",G137&CHAR(10))
&" "&IF(ISBLANK(G138),"",G138&CHAR(10))
&" "&IF(ISBLANK(G139),"",G139&CHAR(10))
&" "&IF(ISBLANK(G140),"",G140&CHAR(10))
&" "&IF(ISBLANK(G141),"",G141&CHAR(10))
&" "&IF(ISBLANK(G142),"",G142&CHAR(10))
&" "&IF(ISBLANK(G144),"",G144&CHAR(10))
&" "&IF(ISBLANK(G146),"",G146&CHAR(10))
&" "&IF(ISBLANK(G159),"",G159&CHAR(10))
&"} "&IF(ISBLANK(G160),"",G160))