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

[Stephen Morley]

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 · Accepted solution]

@Stephen Morley 

=IFERROR(LEFT(A2,FIND(" ",A2)-1),A2)

Maybe with IFERROR in addition to your formula. 

[#3]

Thanks @OliverScheurich, that's perfect