Forum Discussion
textjoin issues
Hello Everyone , I have the text join formula to combine a series of text in a row. But the cells have a vlookup formula to get data from another sheet. When try to join the text resulted in t...
Thanks much for the time . Unfortunately, this one does not work as well.
Do you think it is because the there is some formula already there in the cell ?
Detlef_Lewin Sure . Here it is.
Please be kind to the helpers and do not upload such big files that take ages to load and to calculate.
I deleted some empty rows and some formulas and the conditional formatting because they were all slowing down the spreadsheet. That left 1.7 MB from the original 9 MB.
I created a different solution using Power Query instead of Excel's TEXTJOIN().
The result is still shown as a pivot table.
Detlef_Lewin , My sincere apologies for the inconvenience caused. This won't you repeated again.
Thank you very much for the help and time.