hans2103’s avatarhans2103’s Twitter Archive—№ 6,706

  1. Excel split name on first space. =LEFT(A2,FIND(" ",A2)-1) =RIGHT(A2,LEN(A2)-FIND(" ",A2))