Forum Discussion
SteveMorley1
May 12, 2022Brass Contributor
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.
2 Replies
- OliverScheurichGold Contributor
- SteveMorley1Brass ContributorThanks OliverScheurich, that's perfect