Text to Text Formula Help


Good morning,

I'm looking for a little assistance. I want to create a formula that will change text in one cell if the word is in another cell. For instance, if I have DOG 246 in one cell, I would like the other cell to input DOG, however if the first cell has CAT 123, I want the other cell to input CAT. Any assistance would be appreciated!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!