Hi Col,

Make your procedure a function

Given:

Okay I have a function that in development I was just hitting
from the worksheet.
So in a cell I would enter =concat_clean(A1:Z1)

I assumed that Robert was using a function and the 'Sub' is a typo. It is
wise, however, to make as few assumptions as possible!


---
Regards,
Norman