Use this instead.........

=IF(ISERR(MID(B2,FIND(" ",B2,1)+1,99)),"",MID(B2,FIND(" ",B2,1)+1,99))

Vaya con Dios,
Chuck, CABGx3




"exceluser2" wrote:


great! For the cell "NoMadic" which has no value after it I get the
#VALUE! error. How can I change this to just a blank cell?


--
exceluser2
------------------------------------------------------------------------
exceluser2's Profile: http://www.excelforum.com/member.php...o&userid=31338
View this thread: http://www.excelforum.com/showthread...hreadid=517917