A more complex use of Concatanate......

[Mark McInerney]

Hi Folks,

I have a range of data A1:D1 - the values of the cells are dynamically linked to other cells.

For this example - they are A1 = "0", B1 = "0", C1 = "Cake" and D1 = "Nice"

I need to retrieve only the text strings and place something that delimits them as well - I want the output to be Cake / Nice

Another example A1 = "Karen", B1 = "0", C1 = "0" and D1 = "Wall" - I want the output to be Karen / Wall

Is this possible?

Many Thanks for taking a look - appreciated - Mark.

 

[Fluff]

How about

=TEXTJOIN(" / ",,FILTER(A1:D1,LEN(A1:D1)>1))

 

[JEC]

How about

=TEXTJOIN(" / ",,TEXT(A1:D1,"0;;"))

 

[Mark McInerney]

Genius.....Thank you very much - really appreciated

 

[Fluff]

Glad we could help & thanks for the feedback.