I need a formula that will take the text in one column and create variations of that text in a separate column. The variations would be different capitalizations/lowercase and character differences(and vs &).
Here’s a breakdown…
I need a formula that will take the text in one column and create variations of that text in a separate column. The variations would be different capitalizations/lowercase and character differences(and vs &).
Here’s a breakdown…
Instead of generating all possible variations of text you should rather find a way to normalize both the submission and the answer to some common variation
RegexReplace("\s+", " ")
RegexReplace("[^\w\s]", "")
&
with and
using the same method.Lower()
Answer.ContainsText(Expected, true, true)
— this is a cool function because it’s also capable to ignore variations in áccénts, not only letter case, i.e. returns true on “fjällräven kånken” containing “Fjallraven”This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.