Forum Discussion
Evelyn1710
Jul 22, 2022Copper Contributor
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...
Riny_van_Eekelen
Jul 22, 2022Platinum Contributor
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))