Forum Discussion
Is there a way to compare whether two cells are equal in the numerical value, ignoring the text?
Is there a way to compare whether two cells are equal in the numerical value, ignoring the text? For instance, I want =2=2 years to return TRUE because the 2’s are equal to each other.
The only way is to clean your strings by extracting the numerical value first then comparing them.
There are many ways to extract a number from a string.
There are many ways to extract a number from a string.