TEXTJOIN using IF & "addtext" but remove if cell is blank.

[Sellsie11]

I am trying to TEXTJOIN to create links to my filepaths, whilest adding text that I need - but I don't want it to bring back anything when I have no vaule.
Any help would be massivly appriciated.

Saving file paths for CADS.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	File Path	Style Code	CAD1	CAD2	CAD3	CAD4	CAD5	CAD6	CAD7	CAD8	CAD9	CAD10	CAD11	CAD12	CAD13	CAD14	CAD15	CAD16	CAD17	CAD18
2	Macintosh HD:Users:username:Documents:Clients:filepath:CADS:	PKF293_	61I	E87	4VK	540																Macintosh HD:Users:username:Documents:Clients:filepath:CADS:PKF293_61I_C_1.png,Macintosh HD:Users:username:Documents:Clients:filepath:CADS:PKF293_E87_C_1.png,Macintosh HD:Users:username:Documents:Clients:filepath:CADS:PKF293_4VK_C_1.png,Macintosh HD:Users:username:Documents:Clients:filepath:CADS:PKF293_540_C_1.png,Macintosh HD:Users:username:Documents:Clients:filepath:CADS:PKF293__C_1.png,Macintosh HD:Users:username:Documents:Clients:filepath:CADS:PKF293__C_1.png,Macintosh HD:Users:username:Documents:Clients:filepath:CADS:PKF293__C_1.png,Macintosh HD:Users:username:Documents:Clients:filepath:CADS:PKF293__C_1.png,Macintosh HD:Users:username:Documents:Clients:filepath:CADS:PKF293__C_1.png,Macintosh HD:Users:username:Documents:Clients:filepath:CADS:PKF293__C_1.png,Macintosh HD:Users:username:Documents:Clients:filepath:CADS:PKF293__C_1.png,Macintosh HD:Users:username:Documents:Clients:filepath:CADS:PKF293__C_1.png,Macintosh HD:Users:username:Documents:Clients:filepath:CADS:PKF293__C_1.png,Macintosh HD:Users:username:Documents:Clients:filepath:CADS:PKF293__C_1.png,Macintosh HD:Users:username:Documents:Clients:filepath:CADS:PKF293__C_1.png,Macintosh HD:Users:username:Documents:Clients:filepath:CADS:PKF293__C_1.png,Macintosh HD:Users:username:Documents:Clients:filepath:CADS:PKF293__C_1.png,Macintosh HD:Users:username:Documents:Clients:filepath:CADS:PKF293__C_1.png
Sheet7

Cell Formulas
Range	Formula
V2	V2	=TEXTJOIN(",",TRUE,A2&B2&C2:T2&"_C_1.png")

 

[Weaver]

Try using the LET() formula
=LET(A,TEXTJOIN(",",TRUE,A2&B2&C2:T2&"_C_1.png"),IF(A="","",A))

 

[Sellsie11]

Try using the LET() formula
=LET(A,TEXTJOIN(",",TRUE,A2&B2&C2:T2&"_C_1.png"),IF(A="","",A))

I've never used the LET function before so not entirely sure what it does. I have put it in your suggestion but I am getting exactly the same results are I had before? Is there something else I need to do to make it work? It still creates the 14 paths extra paths I don't need. Thanks

 

[Sanjeev1976]

Try using the below formula :

=TEXTJOIN(",",TRUE,A2&B2&C2:T2&IF(C2:T2<>"","_C_1.png",""))

 

[Sellsie11]

Try using the below formula :

=TEXTJOIN(",",TRUE,A2&B2&C2:T2&IF(C2:T2<>"","_C_1.png",""))

It works on removing the last section "_C_1.png" but not on removing (A2)&(B2) or the comma that is presumably still being brought in by the textjoin.

Thanks

 

[Fluff]

How about

=TEXTJOIN(",",TRUE,A2&B2&FILTER(C2:T2,C2:T2<>"")&"_C_1.png")

 

[Sellsie11]

How about

=TEXTJOIN(",",TRUE,A2&B2&FILTER(C2:T2,C2:T2<>"")&"_C_1.png")

Thank you for your help!

If you don't mind me asking what is it doing exactly? Would the below be correct?
textjoining with comma A2&B2& filtering/matching values in range C2:T2 that are not equal to "" nothing and only brining those ones back?

 

[Fluff]

textjoining with comma A2&B2& filtering/matching values in range C2:T2 that are not equal to "" nothing and only brining those ones back?

That's right.