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
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 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!