Thanks, but it returns "TRUE" everywhere that I had a name before, and it still says "#VALUE!" everywhere else.
[/SIZE][SIZE=6][SIZE=1]=IF(LEN(A1)>0,LEFT(A1,FIND(" ",A1)+1)&".","")[/SIZE]
[/SIZE][SIZE=1]
Just pointing out that I have a friend whose name the suggested formula won't work correctly on. I'll just a made-up last for this example, but this is her real first name...Your IF/THEN is working perfectly for all cells. Thank You! Thank You to the other contributors, as well!