Compare Text


Is there a formula that I can use to compare the amount of similar words between two cells? I have two columns that have similar text but sometimes there is a period or comma that throws of my MATCH formula.



Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Not directly and the complexity of the solution is going to depend on how many different characters you anticipate. Basically we could use some nested SUBSTITUTE functions to strip out those special characters and spaces and compare the results from that.

    =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([1st Text String]@row, "-", ""), " ", ""), ".", "")

    The above removes hyphens, spaces, and periods.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!