View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sisilla[_2_] Sisilla[_2_] is offline
external usenet poster
 
Posts: 34
Default CONCATENATE with CHAR(10) IF NOT ISBLANK

Hello All,

Can anyone tell me why this formula will not work? I do not get any
error messages. The formula is displayed in the cell as its value.

=CONCATENATE(OFFSET(RC, 0, 0), IF(ISBLANK(OFFSET(RC, 0, 4)), "",
CHAR(10)), OFFSET(RC, 0, 4), IF(ISBLANK(OFFSET(RC, 0, 8)), "",
CHAR(10)), OFFSET(RC, 0, 8))


I appreciate any effort to help me. Thank you for your time and
consideration.

Sincerely,

Sisilla