text join formula- SOLVED now

Question

I am trying to combine the text data from 4 adjacent columns into 1 cell in the column. I have tried using the text join formula below but it keeps returning #NAME? can anyone tell me what I am doing wrong or if there is a better way to combine the data rather than retyping it all as that would take days!

=textjoin(",", ignore_empty, B6:G6)

thanks

sergeibaklan · Answer

lauracooper&nbsp;
That is
=TEXTJOIN(",",, B6:G6)
Excel doesn't recognise what the ignore_empty is.

subodh_tiwari_sktneer · Answer

lauracooper&nbsp;&nbsp;ignore_empty is the second argument in the TEXTJOIN function and the allowed values are either TRUE or FALSE.&nbsp;If you want to ignore the empty cells in the range you want to join, you should pass TRUE or you can skip the second argument by typing a comma if you wish as TRUE is the default value for the second argument.&nbsp;&nbsp;&nbsp;&nbsp;=TEXTJOIN(",",TRUE,B6:G6)&nbsp;&nbsp;

lauracooper · Answer

thank you SergeiBaklan this worked. I removed the ignore_empty&nbsp;I am very happy!

lauracooper · Answer

Thank youSubodh_Tiwari_sktneer&nbsp;I will try that too.

sergeibaklan · Answer

lauracooper&nbsp;, glad to help

Forum Discussion

text join formula- SOLVED now

6 Replies

Resources