Forum Discussion
KDAME1984
Aug 24, 2022Copper Contributor
Concatenate Function yields large space
I am using the CONCATENATE function to create a note that fills in from data on a different tab. When I use the function to string everything together, it loads 255 boxes into the function when I go ...
HansVogelaar
Aug 24, 2022MVP
Do you have Excel 2019, 2021 or 365? If so, you can use TEXTJOIN:
=TEXTJOIN(" ",TRUE,A2:A300)