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!

Michael Culley

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)

Laurie

No, it will be either 2 or 3 letters

Laurie

I tried that but it came back as blank