Assuming your data is seperated by spaces, you can try this in a blank
column:
=IF(ISERROR(LEFT(A1,FIND(" ",A1)-1)),IF(A1="","",A1),LEFT(A1,FIND("
",A1)-1))
copied down...once you have done that just copy and paste over your
existing data (Paste as Values).
NOTE! if your data is seperated by something other than "spaces" say
"comas" then change FIND(" " to FIND("," in the formula.
HTH
JG
--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile:
http://www.excelforum.com/member.php...fo&userid=6261
View this thread:
http://www.excelforum.com/showthread...hreadid=496061