Is there any way to modify the UDF to display this:
data1¦data1|data2¦data2|data3¦data3

So the data is duplicated but with a broken pipe, then a pipe until the end
of the string which has no pipe

Also I need to reference a separate worksheet for the data and display in
another sheet.

Thanks


"Excel Helps" wrote:

The UDF works fine,but what do I need to use it to pull data from a different
worksheet. For Example rather than =ConCatRange(A2:E2)
I would like to reference =sheet9!ConCatRange(A2:E2)


"Gord Dibben" wrote:

Thanks Roger.

These old eyes did not pick up the difference in the piping.

Gord

On Sun, 20 Jan 2008 10:38:10 -0000, "Roger Govier"
<roger@technology4unospamdotcodotuk wrote:

Hi Gord

I don't think that will work.
the OP is using two different forms of pipe between the text
red¦red|white¦white|blue¦blue|