Return the first whole word found in a target cell.

[tbablue]

A1, I want to return the first whole word found in B1.

B1 is populated by formula.


Any help gratefully rec'd.

 

[Peter_SSs]

Try

=LEFT(B1,FIND(" ",B1&" ")-1)

 

[tbablue]

Thanks Peter.