formatting linked cells

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top