Forum Discussion
I need to Combine a List numbers with no spaces
How can I combine numbers from one column into one cell with commas but no space in between. Example: 1,2,3,4,5 I tried using =TEXTJOIN(“,”,TRUE,A1:A68) and I tried the CONCAT option. They seem to d...
Can't replicate that issue when working with real numbers, but if the "numbers" in the Excel file are in fact texts, they might include leading and/or trailing spaces. Wrap the range at the end of the TEXTJOIN in TRIM, so that it will look like this: =TEXTJOIN(",",TRUE,TRIM(A1:A68))