Home

Problem using Textjoin with concatenate

Syl1017
New Contributor

I have a TEXTJOIN formula that concatenates text based on an IF function.  The IF function looks at a range in column A and if the value in cell A1:A5>0, it concatenates text in B1:B5 with a ", " delimiter between each.  It is capturing all the correct text cells, but it is also adding an extra "0, 0," between each text string.  What am I doing wrong?

1 Reply
Resolved.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies