ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   formatting linked cells (https://www.excelbanter.com/excel-discussion-misc-queries/213157-formatting-linked-cells.html)

jase

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


All times are GMT +1. The time now is 07:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com