SyntaxFix
Write A Post
Hire A Developer
Questions
I found this on exceljet.net and works for me:
=LEFT(B4,FIND(" ",B4)-1)