SOLVED

Textjoin function returns long empty space or thousands of delimiters

%3CLINGO-SUB%20id%3D%22lingo-sub-2570945%22%20slang%3D%22en-US%22%3ETextjoin%20function%20returns%20long%20empty%20space%20or%20thousands%20of%20delimiters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2570945%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emy%20text%20join%20function%20delivers%20strange%20results.%20I%20have%20a%20lot%20of%20space%20between%20the%20two%20joined%20texts%20and%20if%20I%20put%20a%20delimiter%20I%20have%20many%20hundreds%20of%20those%20in%20between%20these%20texts%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anybody%20experienced%20that%20error%3F%20I%20could%20not%20find%20anything%20on%20the%20web%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help.%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3EYannick%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2570945%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2571042%22%20slang%3D%22en-US%22%3ERe%3A%20Textjoin%20function%20returns%20long%20empty%20space%20or%20thousands%20of%20delimiters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2571042%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F592426%22%20target%3D%22_blank%22%3E%40hoffecbm%3C%2FA%3E%26nbsp%3BAt%20the%20end%20of%20your%20formula%20you%20have%20%22%20%22.%20Try%20%22%22%2C%20then%20the%20cell%20will%20become%20empty%20and%20then%20the%20TEXTJOIN%20formula%20will%20skip%20it.%20Beware%20that%20a%20cell%20with%20%22%20%22%20is%20not%20an%20empty%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

2 Replies
best response confirmed by hoffecbm (New Contributor)
Solution

@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.