Forum Discussion
Solved
Textjoin function returns long empty space or thousands of delimiters
Dear all,
my text join function delivers strange results. I have a lot of space between the two joined texts and if I put a delimiter I have many hundreds of those in between these texts
Has anybody experienced that error? I could not find anything on the web
Thanks for your help.
Best regards,
Yannick
hoffecbm At the end of your formula you have " ". Try "", then the cell will become empty and then the TEXTJOIN formula will skip it. Beware that a cell with " " is not an empty cell.
2 Replies
hoffecbm At the end of your formula you have " ". Try "", then the cell will become empty and then the TEXTJOIN formula will skip it. Beware that a cell with " " is not an empty cell.
- Thank you. That was it
