Text to Text Formula Help
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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.7K Get Help
 406 Global Discussions
 217 Industry Talk
 456 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!