0

This:

=CONCATENATE({"A","B"})

only returns "A". Desired result would be "AB".

This is just an example, I'm interested in using this with results of array formulas but don't know how or if it's even possible.

I'm on Excel 2010

andrewb
  • 1,129
  • 5
  • 9
  • Try =CONCAT({"A","B"}) instead – user11222393 Feb 15 '23 at 14:01
  • @user11222393 thank you but that formula is unfortunately not available in Excel 2010. – andrewb Feb 15 '23 at 14:01
  • Depending on the situation, you could use the '&' symbol; e.g. ="A"&"B" – gingerox Feb 15 '23 at 14:17
  • @gingerox yes but the point is to concatenate an array the number of elements and contents of which I don't know. – andrewb Feb 15 '23 at 14:31
  • 2
    @andrewb not with native formula. You will need VBA. You can use the TEXTJOIN UDF noted here: https://stackoverflow.com/questions/42165179/ms-excel-concat-with-a-delimiter/42165195#42165195 and use `""` as the delimiter. – Scott Craner Feb 15 '23 at 15:17
  • @ScottCraner Thank you. I wanted to go without VBA. So it is not possible then :( Oh well. – andrewb Feb 15 '23 at 16:22
  • Correct in Excel 2010 without dynamic array formula, it is not possible to concatenate a dynamic array. You would need to use IF statements for each possibility and concatenate those, but that will get unruly if you have a large number of data points to test. – Scott Craner Feb 15 '23 at 16:28

0 Answers0