Concatenate Function yields large space

Question

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 beyond 5. The result when I copy/paste to a medical record system is a huge space at the end of the note that I believe is coming from the&nbsp;CONCATENATE function. There are no spaces after the&nbsp;CONCATENATE text in the box. How do I get rid of the extra space or the extra function lines in the&nbsp;CONCATENATE function?

detlef_lewin · Answer

KDAME1984&nbsp;CONCATENATE() does not produce spaces. There must already be in the cells.However I do not understand what you mean be "loading 255 boxes" and "going beyond 5",&nbsp;

hansvogelaar · Answer

KDAME1984&nbsp;
Do you have Excel 2019, 2021 or 365? If so, you can use TEXTJOIN:
&nbsp;
=TEXTJOIN(" ",TRUE,A2:A300)

Forum Discussion

Concatenate Function yields large space

2 Replies

Resources