Add prefix to filter function-CodePudding

Is there a Way to add a prefix to the filter function so the result looks like this:

Prefix Value1
Prefix Value2
Prefix Value3

I already tried things like:

="Prefix "&FILTER(Data;condition1;condition2)

wich resulted in just the first Value of the filter got returned with the prefix the rest didnt got returned.

Prefix Value1

also tried this:

=TEXTJOIN("Prefix ";FILTER(Data;condition1;condition2))

This resulted in:

Prefix ReturnValue1ReturneValue2ReturnValue3

so my current workaround is to just Filter in another column and in the column I want the prefix with the filter I just say

="Prefix "&B1
="Prefix "&B2
="Prefix "&B3
...

This reults in about 8000 Cells that need to be recalculated each time something changes.

CodePudding user response：

You can use the concatenate function or the '&' operator in your filter.

Function: