Forum Discussion
Solved
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...
Horizontal Alignment has been set to Fill. This causes Excel to repeat the cell value to fill the cell.
Set Horizontal Alignment to General to solve the problem.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Yes, I was able to replicate the TextJoin issue by copying the table over to a new Excel file and renaming items.
On the other hand I was unable to replicate the Ampersand issue, which returns the same result, in the new Excel file, but I am still getting the same erroneous result if I replace the current TextJoin formula with the ampersand-based one.