Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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))
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Carry over formatting between linked cells. WDS Excel Discussion (Misc queries) 3 November 8th 08 02:05 AM
Sorting non-linked cells in a linked worksheet Gary Excel Discussion (Misc queries) 1 October 25th 08 03:38 AM
Formatting Linked Cells Billy Bob Danny Frank Excel Discussion (Misc queries) 1 April 17th 07 05:16 AM
Linked Cells Staying With Cells Once Linked Workbook Update. [email protected] Excel Worksheet Functions 0 June 6th 06 09:32 AM
Transfer Cell Formatting for linked cells Scott Excel Discussion (Misc queries) 2 November 23rd 05 11:04 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"