Off topic.....

=INDEX(A:A............

Does Index index the entire column of just the used range?

Biff

"Harlan Grove" wrote in message
oups.com...
wrote...
...
The following is the ugly solution I'm currently leveraging:

=CONCATENATE(
IF(ISTEXT('Interview Summary'!$A$77),
'Interview Summary'!$A$77,""),
IF(ISTEXT('Interview Summary'!$A$78),CHAR(10)&
'Interview Summary'!$A$78,""),
IF(ISTEXT('Interview Summary'!$A$79),CHAR(10)&
'Interview Summary'!$A$79,""),
IF(ISTEXT('Interview Summary'!$A$80),CHAR(10)&
'Interview Summary'!$A$80,""),
IF(ISTEXT('Interview Summary'!$A$81),CHAR(10)&
'Interview Summary'!$A$81,""),
IF(ISTEXT('Interview Summary'!$A$82),CHAR(10)&
'Interview Summary'!$A$82,""),
IF(ISTEXT('Interview Summary'!$A$83),CHAR(10)&
'Interview Summary'!$A$83,""),
IF(ISTEXT('Interview Summary'!$A$84),CHAR(10)&
'Interview Summary'!$A$84,""),
IF(ISTEXT('Interview Summary'!$A$85),CHAR(10)&
'Interview Summary'!$A$85,""),
IF(ISTEXT('Interview Summary'!$A$86),CHAR(10)&
'Interview Summary'!$A$86,""),
IF(ISTEXT('Interview Summary'!$A$87),CHAR(10)&
'Interview Summary'!$A$87,""),
IF(ISTEXT('Interview Summary'!$A$88),CHAR(10)&
'Interview Summary'!$A$88,""),)
...

First off, don't mix CONCATENATE and &. At the very least it's
confusing. Better to use & everywhere.

If you won't have any embedded linefeed or ASCII 127 (DEL) chars in
any of these cells' contents, you could try

=SUBSTITUTE(SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE(
T('Interview Summary'!$A$77)&CHAR(10)&
T('Interview Summary'!$A$78)&CHAR(10)&
T('Interview Summary'!$A$79)&CHAR(10)&
T('Interview Summary'!$A$80)&CHAR(10)&
T('Interview Summary'!$A$81)&CHAR(10)&
T('Interview Summary'!$A$82)&CHAR(10)&
T('Interview Summary'!$A$83)&CHAR(10)&
T('Interview Summary'!$A$84)&CHAR(10)&
T('Interview Summary'!$A$85)&CHAR(10)&
T('Interview Summary'!$A$86)&CHAR(10)&
T('Interview Summary'!$A$87)&CHAR(10)&
T('Interview Summary'!$A$88)&CHAR(10)&
""," ",CHAR(127)),CHAR(10)," "))," ",CHAR(10)),CHAR(127)," ")

Still ugly, but more easily extended.