Hi, I have a Database which I need only one contact name for each company.
Unfortunately, there is up to 5 different names in each cell. Eg. "Smith Jones Walton Davies Wilson"

Could anyone help me with a formula that lets me just keep the first name in the cell… "Smith"

Thanks guys!