Tom’s Tutorials For Excel: Extracting the First Word or String in a Cell
Here is an example for returning the first word in a cell, with a formula that can be easily modified to return all contents to the left of the first found specified character in a cell.
In the picture, the example at the left returns the first word in the cells in column A, with this formula in cell B4 and copied down:
What’s happening is, the first (left-most) space character
" " is found. The formula returns all cell contents to the left of that first space, which are letters that form the first word in those sentences.