Picking out one word from a phrase

Hi Eoin

Thanks for your question

The tool you are probably looking for is Text to Columns, which is located on the data menu

Select the cells that contain the data and run text to columns
Select Delimited and click next
Select the separator character (in the example you give a space)

Click Finish

Hope this helps

Regards

Stephen