Text to Text Formula Help
Options
Laurie
✭✭
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!
Tags:
Answers

Will the text always be 3 letters? If so, you can just use =LEFT([column]@row,3)
If there will always be a space in between what you want to keep, you can use:
=LEFT([column]@row, FIND(" ", [column]@row)  1)

No, it will be either 2 or 3 letters

I tried that but it came back as blank
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!