H
harwookf
Excel 2007. I have added the formula shown below to concatenate 26 cells on
a different worksheet, with each one showing on a separate line. However, if
there is a blank cell, it shows as a blank line when really I don't want this
to be included. Is there an easy way to solve this, perhaps with an easier
formula?
Also, I have row to set to auto-height, but yet it doesn't seem to
automatically alter when required. Is there a way to solve this?
Thanks in advance.
=CONCATENATE('Input Notes Sheet'!C2,CHAR(10),'Input Notes
Sheet'!C3,CHAR(10),'Input Notes Sheet'!C4,CHAR(10),'Input Notes
Sheet'!C5,CHAR(10),'Input Notes Sheet'!C6,CHAR(10),'Input Notes
Sheet'!C7,CHAR(10),'Input Notes Sheet'!C8,CHAR(10),'Input Notes
Sheet'!C9,CHAR(10),'Input Notes Sheet'!C10,CHAR(10),'Input Notes
Sheet'!C11,CHAR(10),'Input Notes Sheet'!C12,CHAR(10),'Input Notes
Sheet'!C13,CHAR(10),'Input Notes Sheet'!C14,CHAR(10),'Input Notes
Sheet'!C15,CHAR(10),'Input Notes Sheet'!C16,CHAR(10),'Input Notes
Sheet'!C17,CHAR(10),'Input Notes Sheet'!C18,CHAR(10),'Input Notes
Sheet'!C19,CHAR(10),'Input Notes Sheet'!C20,CHAR(10),'Input Notes
Sheet'!C21,CHAR(10),'Input Notes Sheet'!C22,CHAR(10),'Input Notes
Sheet'!C23,CHAR(10),'Input Notes Sheet'!C24,CHAR(10),'Input Notes
Sheet'!C25,CHAR(10),'Input Notes Sheet'!C26,CHAR(10))
a different worksheet, with each one showing on a separate line. However, if
there is a blank cell, it shows as a blank line when really I don't want this
to be included. Is there an easy way to solve this, perhaps with an easier
formula?
Also, I have row to set to auto-height, but yet it doesn't seem to
automatically alter when required. Is there a way to solve this?
Thanks in advance.
=CONCATENATE('Input Notes Sheet'!C2,CHAR(10),'Input Notes
Sheet'!C3,CHAR(10),'Input Notes Sheet'!C4,CHAR(10),'Input Notes
Sheet'!C5,CHAR(10),'Input Notes Sheet'!C6,CHAR(10),'Input Notes
Sheet'!C7,CHAR(10),'Input Notes Sheet'!C8,CHAR(10),'Input Notes
Sheet'!C9,CHAR(10),'Input Notes Sheet'!C10,CHAR(10),'Input Notes
Sheet'!C11,CHAR(10),'Input Notes Sheet'!C12,CHAR(10),'Input Notes
Sheet'!C13,CHAR(10),'Input Notes Sheet'!C14,CHAR(10),'Input Notes
Sheet'!C15,CHAR(10),'Input Notes Sheet'!C16,CHAR(10),'Input Notes
Sheet'!C17,CHAR(10),'Input Notes Sheet'!C18,CHAR(10),'Input Notes
Sheet'!C19,CHAR(10),'Input Notes Sheet'!C20,CHAR(10),'Input Notes
Sheet'!C21,CHAR(10),'Input Notes Sheet'!C22,CHAR(10),'Input Notes
Sheet'!C23,CHAR(10),'Input Notes Sheet'!C24,CHAR(10),'Input Notes
Sheet'!C25,CHAR(10),'Input Notes Sheet'!C26,CHAR(10))