View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jase jase is offline
external usenet poster
 
Posts: 117
Default formatting linked cells

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))