Getting the First Word

If you want to return the first word from a text string, still using the text Our main business focus is Excel spreadsheets in cell A2, enter in the following function in cell B3:

This formula will display the word Our in cell B3, by using a combination of the LEFT function (to return the first character or characters in a text string, based on the number of characters you specify) and the FIND function to locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string.