Thanks all.

"Bob Phillips" wrote:

> Won't happen if you want the array to be variable and the formula to cope
> with it, as CONCATENATE won't support arrays, so you need a UDF
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "ExcelMonkey" <ExcelMonkey@discussions.microsoft.com> wrote in message
> news:FA400C83-C1E9-455E-AFD7-22FEE45B6E19@microsoft.com...
> > Can anybody tell me how to do a conditional concatenate. I have to
> columns
> > of data. Column A has numbers: 1-5 (A2:A6). Column B has booleans:
> > TRUE/FALSE (B2:B6)
> >
> > A B
> > 1 TRUE
> > 2 FALSE
> > 3 TRUE
> > 4 FALSE
> > 5 TRUE
> >
> > in B7 I want to do an conditional concatenate using "&" character on
> column
> > A using the booleans in column B. The result would like like this:
> &1&3&5.
> > Note there is a "&" before the first number as well.
> >
> > Thanks
>
>
>