Forum Discussion

SteveMorley1's avatar
SteveMorley1
Brass Contributor
May 12, 2022
Solved

Help with an Excel formula with conditions based on a single text cell with multiple values

I have a column with multiple values possible in it.  I'm trying to extract the first word from each cell in the column.  As above, you can see I've got a formula for the condition if there are multiple words in the cell.
In cell A2, you see there are no spaces, so the formula of =LEFT(A2,FIND(" ",A2)-1) won't work.
What I would like is a formula that would capture both conditions:
If there is one word, display that word, if a space is found, display the left-most word.

Any help would be appreciated.