Forum Discussion
Solved
Possible to remove text between delimiters that comes from the =FILTER formula?
I am using the Azure Devops plugin to retrieve data from a query in Devops in one worksheet of my workbook. In the second worksheet, I am using the =FILTER formula to display text from a range of col...
Here's a scaled down example with TEXTBEFORE:
=LET(filtered,FILTER(name,team="red"),TEXTBEFORE(filtered,"<",,,,filtered))
Here's a scaled down example with TEXTBEFORE:
=LET(filtered,FILTER(name,team="red"),TEXTBEFORE(filtered,"<",,,,filtered))