textjoin

Greetings again! Is there a way to get TEXTJOIN to keep the trailing zeros when having it pull numbers? I have the reference cells set up to carry out to three decimal places. When I use TEXTJOIN to combine data (text and numbers) it's removing the trailing zeros that I need on my numbers...

Hey Everyone, How do I textjoin every 3 columns? data is on one sheet, results on another. example below: Data sheet <tbody> Dog cat Fish Car Truck Plane </tbody> Results sheet <tbody> Dog, Cat, Fish Car, Truck, Plane </tbody> Thanks Andrew

Hi, Is it possible to textjoin and skip cells with the number zero. I understand I can skip blank cells with true/false etc but zero's are not blank. Example below: <tbody> 1 2 0 3 4 1,2,3,4 </tbody> Thanks Andrew

Hi! I have the following situation: In a large table I have conditions in column A and values in column B. I want to create a list of those values in B which meet a given condition in column A ("textjoinif"). To do so I basically have TEXTJOIN(", ";TRUE; IF(columnA="example";columnB;"")). Yet...

Hi I was wondering if there is possible to make a TEXTJOIN formula to only pick up the name one time? Ex; A1=Mark A2=Robert A3=Robert. Then the cell with the TEXTJOIN formula should only have Mark, Robert. I have made this formula but need help with my problem :-) =TEXTJOIN(",",TRUE,O76:O81)