Try this:
assuming your column A is the column with your data with blank rows in
between and column B is where you want the results then.

=IF(A2<"",LEFT(A2,FIND(" ",A2)-1),B1)
start this formula in the same row as your first bit of data and copy
down.

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=498874