Textjoin or simple “&” returns duplicate results when used on Table
I’ve used Textjoin on multiple occasions without problem, or its simple equivalent, the humble ampersand. If we use the below example:
Cell A1: 10
Cell B1: James
Cell C1: ()
Let’s say I use the “,” delimiter in Textjoin or add that criteria in a simple “&”. In all cases I shold end up with: 10,James,()
But for some reason, when applying either of these solutions to a named Table in desktop Excel app, I keep getting this result: 10,James,()10,James,() minus the colors obviously.
In other words, the results of either formula are completely duplicated, only omitting the middle “,”. Doesn’t even matter which approach I choose, and there aren’t any formulas running in the cells that I am referencing.
Has anyone experienced anything similar?
I’ve used Textjoin on multiple occasions without problem, or its simple equivalent, the humble ampersand. If we use the below example: Cell A1: 10Cell B1: JamesCell C1: () Let’s say I use the “,” delimiter in Textjoin or add that criteria in a simple “&”. In all cases I shold end up with: 10,James,() But for some reason, when applying either of these solutions to a named Table in desktop Excel app, I keep getting this result: 10,James,()10,James,() minus the colors obviously. In other words, the results of either formula are completely duplicated, only omitting the middle “,”. Doesn’t even matter which approach I choose, and there aren’t any formulas running in the cells that I am referencing. Has anyone experienced anything similar? Read More