Forum Discussion
Textjoin or simple "&&" returns duplicate results when used on Table
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.
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.
- Thanks, that worked! I didn't imagine that would cause such an issue.
On a related note, as this seems to have caused the issue, is there a way to stop cell contents overflowing if I shrink the column width, without using the Fill option in Alignment?One option is to turn on Wrap Text. This may increase the row height to fit the text.
Another is to turn on Shrink to Fit in the Alignment tab of the Format Cells dialog.