How to Clear formatting or compare identical text with dissimilar formatting

I have a task called “Run Month End Calculations”. I have a formula that compares that text to “Run Month End Calculations”.

It returns false. If the text was different due to capitalization issues, I would just run .Lower() on both before comparing… but how do I clear formatting before comparing two texts?

Found that if I run .ToText() on both, then they compare as equal.

1 Like