On Thu, 16 Jun 2005 12:26:38 +0100, "Bob Phillips"
wrote:

It can be worse if they include {..} in their response as you then have to
remove them. But this is similar to long formulae that extend over multiple
lines, I have to re-join these back in Excel.

But only remove those brackets that are at the beginning and end of the
formula; don't remove any brackets that are inside the formula as they
represent array constants.

e.g.

{=SUM(--(A1:A10={1,2,3,4}))}

Remove the outside brackets and not those representing the array constant:

=SUM(--(A1:A10={1,2,3,4}))


--ron