Forum Discussion
Jakamomo
Jan 24, 2022Copper Contributor
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...
Jakamomo
Jan 25, 2022Copper Contributor
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
Jan 26, 2022Bronze Contributor
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"