There is no native excel worksheet function that will concatenate an array. You either have to concatenate IF functions as per joeu2004's suggestion (which might be impractical for large ranges) or use VBA