ResellerRatings Store Ratings - View Single Post

DVNT1 · 01-04-2004, 09:13 AM

if the name was in A1, then...

B1 =LEFT(A1,(FIND(" ",A1)))
C1 =MID(A1,(FIND(" ",A1)+1),LEN(A1)-FIND(" ",A1))

01-04-2004, 09:13 AM	#2 (permalink)
DVNT1 Registered User Join Date: Oct 2001 Location: Ohio Posts: 5,577	if the name was in A1, then... B1 =LEFT(A1,(FIND(" ",A1))) C1 =MID(A1,(FIND(" ",A1)+1),LEN(A1)-FIND(" ",A1))