If you always want the first word, then
=Left([yourField;InStr([yourField];" ")-1)
but you'll have issues if the first word has been entered as an initial only.
Sorry, just re-read your question and this does not check for a space character.
Try this.
=Left([yourField],abs(instr([yourField],"...