Forum Discussion

lauracooper's avatar
lauracooper
Copper Contributor
Jun 18, 2020

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...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 18, 2020

lauracooper 

That is

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

Excel doesn't recognise what the ignore_empty is.

  • lauracooper's avatar
    lauracooper
    Copper Contributor
    Jun 18, 2020

    thank you SergeiBaklan this worked. I removed the ignore_empty 

    I am very happy!

Resources