Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Carry over formatting between linked cells. | Excel Discussion (Misc queries) | |||
Sorting non-linked cells in a linked worksheet | Excel Discussion (Misc queries) | |||
Formatting Linked Cells | Excel Discussion (Misc queries) | |||
Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions | |||
Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) |