Forum Discussion
We are using Excle as a DB tool with the search function of =Filter
The full command is:
=FILTER(DataSet[#All],ISNUMBER(SEARCH(D6,DataSet[[#All],[Answer]])),"No Data")
This command allows me to search on a word or partial word and display all the mentions of the word in the Problem or Solution side of the information stored.
My problem is that all the text that is displayed is stripped of any formatting (Bold or colored or etc). Is there a way to retain the formatting?
No, FILTER just returns the values of the cells satisfying the condition, not their formatting, nor their formulas.
Is there a function that will return the text and the formatting?HansVogelaar
No, there isn't.
