Merging Cells in an Array

  • Thread starter Thread starter Wetsel00
  • Start date Start date
W

Wetsel00

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)
 
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?
 
Back
Top