How to return only the first word from a cell (function help

[Shezza]

Was wondering if anyone could help with this.

Wanted to only return only the first word from a cell with multiple words in text.

Eg. Cell A5 is "Michael Jordan Brian Bob"
I need Cell B5 to return only "Michael"

Lookied into TRIM function, but I think you have to state the number of characters, etc. And the Text to Columns is a possible option, but does not deliver what I want and is not a function that can be applied to new records, etc.

Thanks

 

[barry houdini]

Try

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

 

[Shezza]

Thanks Barry -- appreciate it