May 12 2022 06:59 AM
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.
May 12 2022 07:11 AM
SolutionMay 12 2022 09:17 AM
May 12 2022 07:11 AM
Solution=IFERROR(LEFT(A2,FIND(" ",A2)-1),A2)
Maybe with IFERROR in addition to your formula.