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!