excel pull all text before ; code example

Example: excel everything up to first space

=LEFT(A1,(FIND(" ",A1,1)-1))