This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a "Color" column in the workflow
I would like to standard all the data of Color Column following this Excel Column "Color Name"
So i would like my outcome to be like this
*I have tried using the formula using IF Contain, it works but imagine if i have thousands of data and using formula seems crazy.
I would suggest trying the Fuzzy Match Tool. Given the small number of colors and that the spellings are all different from each other, it should be fairly robust.