excel copy value after character code example

Example 1: excel get after character

=LEFT(text,FIND(character,text)-1)

Example 2: excel everything up to first space

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