Forum Discussion

Jakamomo's avatar
Jakamomo
Copper Contributor
Jan 24, 2022

TEXTJOIN NAME error

Hey Folks, I'm a carpenter masquerading as an excel user and have hit a roadblock since recently converting my estimate master workbook from an "online" spreadsheet to Excel Proper. I'm on Win 10 usi...
excel
Martin_Weiss's avatar
Martin_Weiss
Bronze Contributor
Jan 25, 2022

Hi Jakamomo 

 

the screenshot that you provided does not look like Microsoft 365 to me, it looks more like Excel 2016.

And TEXTJOIN is only availabe since Excel 2019, but not in Excel 2016.

 

Could you please double-check?

  • Jakamomo's avatar
    Jakamomo
    Copper Contributor
    Jan 25, 2022

    Martin_Weiss Aw snap... I think I got it. The file was opening in the old excel version not the upgrade (which I just did yesterday)

    Looks like I'll have to re-write every instance of the textjoin line with a fresh one, the formula from the original document (created in Google sheets and exported to .xlsx) has characters and a Return added to it:

     

    =@TEXTJOIN("

    ",TRUE,B11:B18)

     

    Is there a find/replace function that I can use to make this editing easier for the whole workbook?

     

    Thank you!

    • Martin_Weiss's avatar
      Martin_Weiss
      Bronze Contributor
      Jan 26, 2022

      Jakamomo 

       

      you can search and replace the Return/Line break with the regular Find/Replace function:

       

      In the field "Find what" you just hit the Ctrl+J key (the field will still look empty)

      And the "Replace" with" you leave empty

      Then do a "Replace All"

       

Resources