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?