Quote Originally Posted by Rick Rothstein View Post
Sorry, two more questions...

1) Where did you want the output to go to and did you still want the EmptyCell/DashedCells separator between the concatenated text?

2) Is your "data" text constants or formulas (I notice you have some #NAME? errors in there)?

Rick, data can go into the adjacent columns to the right of the data fields. All is text, but that field shows an error because the cell starts with an "=".

thanks for taking a look at this...

JOHN