you've posted everything other than a sample of what the incorrect data
looks like. I will assume "HP\Compaq DL 585 G1", looks like "
HP HP\Compaq DL 585 G1", ie with a space.

This forumula searches to see if there is a space. If there is, it
takes the first half of the cell and uses that

=IF(ISERR(SEARCH(" ",A2)),A2,LEFT(A2,SEARCH(" ",A2)-1)&" "&B2)


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553833