Forum Discussion
text join formula- SOLVED now
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...
ignore_empty is the second argument in the TEXTJOIN function and the allowed values are either TRUE or FALSE.
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.
=TEXTJOIN(",",TRUE,B6:G6)
Thank youSubodh_Tiwari_sktneer
I will try that too.
You're welcome lauracooper!