Forum Discussion
Solved
Prevent Spilled Array
PC/Windows 10 Excel Version 2303 Build 16.0.16227.20202 64-bit I want to list out a range of cells (D36:D63) but when I do, Excel spills the array into blank cells underneath. My work around is ...
assuming you have 365 then you can use TEXTJOIN and even give deliminator like a comma ","
if you don't have access to TEXTJOIN you can use CONCAT(D36:D72 & ","), but I think TEXTJOIN and CONCAT we added at the same time but it is possible a copy of excel 2019 might have concat and not textjoin I suppose.I just noticed you skip a few cells so you will have to break the areas apart:
=TEXTJOIN(",",true, D36:D63, D66:D68, D71:D72)
CONCATENATE did not work, I opened it in 365 to try TEXTJOIN but I am having issues with the function.
you needed the "" around that semi-colon
I take that back, your cells already have the ; so you don't need a deliminator at all