Textjoin

[Deelof]

Using the following Textjoin formula but how can i adapt the result to remove/ignore "H", "W", "D", DIA", "SH", "AH" where their cells are blank?

=TEXTJOIN(" / ",TRUE,C6,L6:U6,TEXTJOIN(" ",TRUE,"H",TEXTJOIN(" ",TRUE,V6,TEXTJOIN(" ",TRUE,TEXTJOIN(" ",TRUE,"W",TEXTJOIN(" ",TRUE,W6,TEXTJOIN(" ",TRUE,"D",X6,TEXTJOIN(" ",TRUE,"DIA",Y6,TEXTJOIN(" ",TRUE,"SH",Z6,TEXTJOIN(" / ",TRUE,"AH",Z6,TEXTJOIN(" / ",TRUE,TEXTJOIN(" / ",TRUE,AB6,AC6))))))))))))

MEDIA UNIT / BLACK / BAMBOO / WOOD VENEER / BLACK METAL LEGS / H 550 W 1400 D 420 DIA SH AH / CRIB 5 / LEGS

 

[Fluff]

Hi & welcome to MrExcel.
I think your only option is to do it like

=TEXTJOIN(" / ",TRUE,C6,L6:U6,IF(V6<>"","H "&V6,"")&IF(W6<>""," W " & W6,"")&IF(X6<>""," D "&X6,""),AB6,AC6)

 

[Deelof]

=TEXTJOIN(" / ",TRUE,C6,L6:U6,IF(V6<>"","H "&V6,"")&IF(W6<>""," W " & W6,"")&IF(X6<>""," D "&X6,""),AB6,AC6)

Thank you, that's worked a treat!

 

[Fluff]

You're welcome & thanks for the feedback.