Shaun
=IF(W1<>"",IF(ISERROR(CLEAN(TRIM((LEFT(Meetings!W1,FIND("-",Meetings!W1,1)-1))))),CLEAN(TRIM(Meetings!W1)),CLEAN(TRIM(LEFT(Me etings!W1,FIND("-",Meetings!W1,1)-1)))),"")
Is the space in meetings after LEFT a typo or not
Regards Beton