I know it gives an error message when looking up merged cells in an
array, but I want to merge the result of an array. For example I'm
looking up comments for certain positions based on the position and
level, then I want to merge the comments over about four cells, but I
get an error if I change anything about the formula. Suggestions?

You can only concatenate text data in a cell. if you have a number you first
have to convert it to text with the test() function.

if A1 = 123
B1 = "Hello "

C1 =concatenate(text(A1,"general"),B1)

" wrote:

I know it gives an error message when looking up merged cells in an
array, but I want to merge the result of an array. For example I'm
looking up comments for certain positions based on the position and
level, then I want to merge the comments over about four cells, but I
get an error if I change anything about the formula. Suggestions?

With those values in A1 and B1,what difference do you get between
=concatenate(text(A1,"general"),B1) and =concatenate(A1,B1) or just =A1&B1,
Joel?
Which version of Excel?
--
David Biddulph

"Joel" wrote in message
...
You can only concatenate text data in a cell. if you have a number you
first
have to convert it to text with the test() function.

if A1 = 123
B1 = "Hello "

C1 =concatenate(text(A1,"general"),B1)

" wrote:

I know it gives an error message when looking up merged cells in an
array, but I want to merge the result of an array. For example I'm
looking up comments for certain positions based on the position and
level, then I want to merge the comments over about four cells, but I
get an error if I change anything about the formula. Suggestions?