text join formula- SOLVED now

[lauracooper]

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

[#2]

@lauracooper 

That is

=TEXTJOIN(",",, B6:G6)

Excel doesn't recognise what the ignore_empty is.

[#3]

@lauracooper 

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)

[#4]

thank you @Sergei Baklan this worked. I removed the ignore_empty 

I am very happy!

[#5]

Thank you@Subodh_Tiwari_sktneer 

I will try that too.

[#6]

@lauracooper , glad to help

[#7]

You're welcome @lauracooper!